SQL语句基础学习之SQL语法总结

从“表名”中选择“字段”

Distinct
从“表名”中选择DISTINCT“字段”

WHERE
从“表名”
中选择“字段”
，其中“条件”

和/或
从“表名”
中选择“字段”
，其中“简单条件”
{[和|或]“简单条件”}+

在
中，从“表名”
中选择“字段”
，其中“字段”在('值1 '，'值2 '，...)

between
从“表名”
中选择“字段”
，其中“字段”的值介于“1”和“2”之间

LIKE
从“表名”
中选择“字段”
，其中“字段”LIKE {pattern}

ORDER
select " field "
FROM " table name "
[WHERE " condition "]
ORDER BY " field "[ASC，DESC]

COUNT
SELECT COUNT(" field ")
FROM " table name "

Group
select "field 1 "，SUM(" field 2 ")
FROM " table name "
GROUP BY " field 1 "

Having
SELECT "field 1 "，SUM(" field 2 ")
FROM " table name "
GROUP BY " field 1 "
HAVING(field)

创建表
创建表“表名”
(“字段1”“字段1数据类型”，
“字段2”“字段2数据类型”，
...)

DROP Table
删除表“表名”

Truncate table
Truncate table " table name "

Insert Into
INSERT INTO“表名”(“字段1”，“字段2”，...)
值("值1 "，"值2 "，...)

UPDATE
UPDATE " table name "
SET " field 1 " =[新值]
其中{condition}

DELETE From
DELETE From " table name "
WHERE { condition }