DML 语句
| 类型 | SQL 实例 | 是否支持 |
|---|---|---|
| INSERT | INSERT INTO tb1_name (col_name,…) VALUES ({expr | FAULT},…),(…),… 或. INSERT INTO tb1_name SET col_name={expr | DEFAULT}, … |
是 |
| UPDATE | UPDATE tb1_name SET col_name1=expr1 [, col_name2=expr2 …] [WHERE where_definition] |
是 |
| DELETE | DELETE FROM tb1_name [WHERE where_definition] | 是 |
| SELECT | SELECT [ALL | DISTINCT | DISTINCTROW ] select_expr, … FROM tb1_name [WHERE where_definition] |
是 |
| REPLACE | REPLACE [LOW_PRIORITY | DELAYED] [INTO] tb1_name [(col_name,…)] VALUES ({expr | DEFAULT},…),(…),… 或 REPLACE [LOW_PRIORITY | DELAYED] [INTO] tb1_name SET col_name={expr | DEFAULT}, … |
否 |
| TRUNCATE | TRUNCATE [TABLE] tb1_name | 否 |
