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 }
0条评论