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 |
否 |