SQL 语句快速参考

SELECT column_name(s)  
FROM table_name  
WHERE condition  
AND|OR condition

ALTER TABLE table_name  
ADD column_name datatype

or

ALTER TABLE table_name  
DROP COLUMN column_name

SELECT column_name AS column_alias  
FROM table_name

or

SELECT column_name  
FROM table_name AS table_alias

SELECT column_name(s)  
FROM table_name  
WHERE column_name  
BETWEEN value1 AND value2

CREATE DATABASE database_name

CREATE TABLE table_name  
(  
column_name1 data_type,  
column_name2 data_type,  
column_name2 data_type,  
...  
)

CREATE INDEX index_name  
ON table_name (column_name)

or

CREATE UNIQUE INDEX index_name  
ON table_name (column_name)

CREATE VIEW view_name AS  
SELECT column_name(s)  
FROM table_name  
WHERE condition

DELETE FROM table_name  
WHERE some_column=some_value

or

DELETE FROM table_name  
( **Note:** Deletes the entire table!!)

DELETE * FROM table_name  
( **Note:** Deletes the entire table!!)

DROP INDEX table_name.index_name (SQL Server)  
DROP INDEX index_name ON table_name (MS Access)  
DROP INDEX index_name (DB2/Oracle)  
ALTER TABLE table_name  
DROP INDEX index_name (MySQL)

DROP TABLE table_name

SELECT column_name, aggregate_function(column_name)  
FROM table_name  
WHERE column_name operator value  
GROUP BY column_name

SELECT column_name, aggregate_function(column_name)  
FROM table_name  
WHERE column_name operator value  
GROUP BY column_name  
HAVING aggregate_function(column_name) operator value

SELECT column_name(s)  
FROM table_name  
WHERE column_name  
IN (value1,value2,..)

INSERT INTO table_name  
VALUES (value1, value2, value3,....)

 _or_

INSERT INTO table_name  
(column1, column2, column3,...)  
VALUES (value1, value2, value3,....)

SELECT column_name(s)  
FROM table_name1  
INNER JOIN table_name2  
ON table_name1.column_name=table_name2.column_name

SELECT column_name(s)  
FROM table_name1  
LEFT JOIN table_name2  
ON table_name1.column_name=table_name2.column_name

SELECT column_name(s)  
FROM table_name1  
RIGHT JOIN table_name2  
ON table_name1.column_name=table_name2.column_name

SELECT column_name(s)  
FROM table_name1  
FULL JOIN table_name2  
ON table_name1.column_name=table_name2.column_name

SELECT column_name(s)  
FROM table_name  
WHERE column_nameLIKE pattern

SELECT column_name(s)  
FROM table_name  
ORDER BY column_name [ASC|DESC]

SELECT column_name(s)  
FROM table_name

SELECT *  
FROM table_name

SELECT DISTINCT column_name(s)  
FROM table_name

SELECT *  
INTO new_table_name [IN externaldatabase]  
FROM old_table_name

 _or_

SELECT column_name(s)  
INTO new_table_name [IN externaldatabase]  
FROM old_table_name

SELECT TOP number|percent column_name(s)  
FROM table_name

TRUNCATE TABLE table_name

SELECT column_name(s) FROM table_name1  
UNION  
SELECT column_name(s) FROM table_name2

SELECT column_name(s) FROM table_name1  
UNION ALL  
SELECT column_name(s) FROM table_name2

UPDATE table_name  
SET column1=value, column2=value,...  
WHERE some_column=some_value

SELECT column_name(s)  
FROM table_name  
WHERE column_name operator value