MySQl Installation, Creating Database and Tables, Inserting Records| My SQL Assignment Help

First, go to the below link and download it:

Link http://dev.mysql.com/downloads/installer/.

Double-click on the MySQL installer file and follow the steps below:

Step 1: Install MySQL Installer

Step 2: Click on Install MySQL Products

Step 3: Download latest product by clicking on the “Find latest products” after check all the checkbox and click on “Execute”

Step 4: Now clicking on “Next” button

Step 5: Choose the setup type after clicking on “Full” checkbox and clicking on “Next”

Step 6: Installation

Step 7: Installation, click on “Execute”, the new window is open for the installation process

Step 8: When the download is completed click on the “Next” button

Step 9: Configuration

After completing all installation click on “Next” button for configuration

Select MySQL password and click on next

Now configuration started:

After all, completion click on “Finish”

After completing Installation we can be creating the database and tables as per the following query:

Now Open MySQL Terminal And Start to Run the queries

After installation is complete everything is in:

C:\mysql.

Now open C:\mysql and go to the mysql server which is probably

C:\mysql\bin

Type "mysql"

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql

You can see:

mysql>

To show databases you can type:

mysql> SHOW DATABASES;

+----------+
| Database |
+----------+
|   mysql  | 
|   test   |  
+----------+
2 rows in set (0.13 sec)

Now you can set the username and password using below command :

mysql> mysqladmin -u root password "new_password";

After setting up the password you can type the below command:

mysql> mysql -u root -p
Enter password:*******

Creating Database

Syntax:

mysql> CREATE DATABASE databasename;

Now if we want to deal with multiple databases then use below query:

Mysql> CREATE DATABASE IF NOT EXISTS EmployeeDatabase; 

After this if you want to show database then use the below query:

Mysql> SHOW DATABASES;

Now choose the database to create the tables

Syntax:

mysql> use database_name;

Example:

mysql> use EmployeeDatabase;

Creating Table Using MySQL:

In this section we will learn how to create a database table and insert record init:

Syntax:

CREATE TABLE [IF NOT EXISTS] `TableName` (`fieldname` dataType [optional parameters]) ENGINE = storage Engine;

Example:

DROP TABLE IF EXISTS emp;
CREATE TABLE emp (
 empno decimal(4,0) NOT NULL,
 ename varchar(10) default NULL,
 job varchar(9) default NULL,
 mgr decimal(4,0) default NULL,
 hiredate date default NULL,
 sal decimal(7,2) default NULL,
 comm decimal(7,2) default NULL,
 deptno decimal(2,0) default NULL
);
 
DROP TABLE IF EXISTS dept;
 
CREATE TABLE dept (
 deptno decimal(2,0) default NULL,
 dname varchar(14) default NULL,
 loc varchar(13) default NULL
);
 
INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
 
INSERT INTO dept VALUES ('10','ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES ('20','RESEARCH','DALLAS');
INSERT INTO dept VALUES ('30','SALES','CHICAGO');
INSERT INTO dept VALUES ('40','OPERATIONS','BOSTON');

Performing Some queries On these tables

Query1: MySQL Query to select “Sal” and “comm” where sal<5000

Solution:

select * 
from (select sal as salary, comm as commission from emp) x 
where salary < 5000;

How to Use “case”:

select ename, 
sal, 
case 
when sal <= 2000 then 'underpaid' 
when sal >= 4000 then 'overpaid' 
else 'ok' 
end as status 
from emp;

If you are a student or database developer, administrator, or someone with a basic understanding of the features of MySQL Hire us and Get your projects done by different Programming Language experts.

If you have project or assignment files, You can send at contact@codersarts.com directly