List of Important My SQL Query used

1.         a)         Create your own database.

 create database Practical;

 

b)         Create table within it with the following fields giving name as Employee

            table.   (Empno,  empname, Job, Salary, Deptno.)

create table Practical.Employee(

Empno int(5),

Empname varchar(50),

Job varchar(50),

Salary float(10,2),

Deptno int(3)

);