Jun 30, 2020
First, go to the below link and download it:
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