Quick Reference for SQL statements

SQL statement

Statement	Syntax
And/or	Select column_name (s) From table_name Where condition And | or condition
Alter table (add column)	Alter table table_name Add column_name datatype
Alter table (drop column)	Alter table table_name Drop column column_name
As (alias for column)	Select column_name as column_alias From table_name
As (alias for table)	Select column_name From table_name as table_alias
Between	Select column_name (s) From table_name Where column_name Between value1 and value2
Create Database	Create Database database_name
Create Index	Create index index_name On table_name (column_name)
Create Table	Create Table table_name ( Column_name1 data_type, Column_name2 data_type, ....... )
Create unique index	Create unique index index_name On table_name (column_name)
Create View	Create view view_name Select column_name (s) From table_name Where condition
Delete from	Delete from table_name (Note:Deletes the entire table !!) Or Delete from table_name Where condition
DROP DATABASE	Drop database database_name
Drop Index	Drop index table_name.index_name
Drop table	Drop table table_name
Group	Select column_name1, sum (column_name2) From table_name Group by column_name1
Having	Select column_name1, sum (column_name2) From table_name Group by column_name1 Having sum (column_name2) condition Value
In	Select column_name (s) From table_name Where column_name In (value1, value2 ,..)
Insert	Insert into table_name Values (value1, value2 ,....) Or Insert into table_name (Column_name1, column_name2 ,...) Values (value1, value2 ,....)
Like	Select column_name (s) From table_name Where column_name Like Pattern
Order	Select column_name (s) From table_name Order by column_name [ASC | DESC]
Select	Select column_name (s) From table_name
Select *	Select * From table_name
Select distinct	Select distinct column_name (s) From table_name
Select (Used to create backup copies of tables)	Select * Into new_table_name From original_table_name Or Select column_name (s) Into new_table_name From original_table_name
Truncate table (Deletes only the data inside the table)	Truncate table table_name
Update	Update table_name Set column_name = new_value [, Column_name = new_value] Where column_name = some_value
Where	Select column_name (s) From table_name Where condition

 

From: http://www.w3school.com.cn/ SQL/SQL _quickref.asp
 

Complete!