>table-name
SET assignment [, assignment]*
[WHERE expr]
assignment ::=
column-name = expr
DELETE
从表中删除行。
语法：
sql-statement ::=
DELETE FROM [database-name .] table-name [WHERE expr]
SELECT
从表中检索数据。
语法：
sql-statement ::=
SELECT [ALL | DISTINCT] result [FROM table-list]
[WHERE expr]
[GROUP BY expr-list]
[HAVING expr]
[compound-op select]*
[ORDER BY sort-expr-list]
[LIMIT integer [( OFFSET | , ) integer]]
result ::=
result-column [, result-column]*
result-column ::=
* | table-name . * | expr [ [AS] string ]
table-list ::=
table [join-op table join-args]*
table ::=
table-name [AS alias] |
( select ) [AS alias]
join-op ::=
, | [NATURAL] [LEFT | RIGHT | FULL] [OUTER | INNER | CROSS] JOIN
join-args ::=
[ON expr] [USING ( id-list )]
sort-expr-list ::=
expr [sort-order] [, expr [sort-order]]*
sort-order ::=
[ COLLATE collation-name ] [ ASC | DESC ]
compound_op ::=
UNION | UNION ALL | INTERSECT | EXCEPT
REPLACE
类似INSERT
语法：
sql-statement ::=
REPLACE INTO [database-name .] table-name 上一页 [1] [2] [3] [4] 下一页 | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 