Monday, August 6, 2012

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)
);