SQL Syntax

For  Quick View we are giving SQL syntax here:

1)SQL Create Database Syntax:

Create Database database name;

2)SQL Drop Database Syntax:

Drop Database database name;

3)SQL Create Table Syntax:

Insert into table name (Column Name1 data type(size), Column Name1 data type(size), Column Name2 data type(size), Column Name3 data type(size));

Insert into table name values(valur1,valu2,value3;)

3)SQL Update Table Syntax:

Upadate Table table name (Column Name1 data type(size), Column Name1 data type(size), Column Name2 data type(size), Column Name3 data type(size));

4)Syntax for SELECT Statement:

If we want to select all columns form the table then the SQL query will be

Select * from tablename;

If we want to select selected columns form the table then the SQL query will be

Select column1, column2, column5 from tablename;

5)SQL WHERE Clause:

Select column1, column2, column5 from tablename where (Condiation);