SQL语句笔记

table：表名

val：某值

col：某列

全大写为SQL关键字

①SELECT

SELECT * FROM table

②DISTINCT

SELECT DISTINCT col FROM table

③WHERE

SELECT * FROM table
WHERE col=val

④AND & OR 放在where后

⑤ORDER BY

SELECT * FROM table
ORDER BY col DESC

⑥INSERT

INSERT INTO table VALUES (val1, val2);
INSERT INTO table (col1, col2) VALUES (val1, val2);

⑦UPDATE

UPDATA table SET col=new_val where col=val

⑧DELETE 

DELETE FROM table WHERE col=val

⑨TOP

返回前n跳数据,SQL才能用

SELECT TOP 2 * FROM table;
SELECT TOP 50 PRECENT * FROM table;

⑩UNION

SELECT col from table1
UNION      --UNION集合，需要重复的就用UNION ALL
SELECT col from table2