SQL语句
+----+--------------+---------------------------+-------+---------+
| id | name | url | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | 淘宝 | https://www.taobao.com/ | 13 | CN |
| 3 | 菜鸟教程 | http://www.runoob.com/ | 4689 | CN |
| 4 | 微博 | http://weibo.com/ | 20 | CN |
| 5 | Facebook | https://www.facebook.com/ | 3 | USA |
+----+--------------+---------------------------+-------+---------+
SELECT 语句
SELECT column_name,column_name FROM table_name;
SELECT * FROM table_name;
SELECT DISTINCT 语句
SELECT DISTINCT column_name,column_name FROM table_name;
//在表中,一个列可能会包含多个重复值,有时您也许希望仅仅列出不同(distinct)的值。DISTINCT 关键词用于返回唯一不同的值。
WHERE 子句
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
WHERE 子句中的运算符
ORDER BY 关键字
SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;
INSERT INTO 语句
INSERT INTO table_name
VALUES (value1,value2,value3,...);
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
UPDATE 语句
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
DELETE 语句
DELETE FROM table_name
WHERE some_column=some_value;
SELECT TOP 子句
SELECT TOP number|percent column_name(s)
FROM table_name;
SELECT LIMIT 语句
SELECT column_name(s)
FROM table_name
LIMIT number;
LIKE 操作符
SELECT column_name(s)
FROM table_name
WHERE column_name (NOT) LIKE pattern;
通配符
IN 操作符
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);
BETWEEN 操作符
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
SQL 别名
SELECT column_name AS alias_name
FROM table_name;
SELECT column_name(s)
FROM table_name AS alias_name;