DELETE
更新时间：2024-02-23
DELETE 语句用于删除表中符合条件的行，本文为介绍了DELETE语句的语法和相关限制。
语法
单表语法
Plain Text
1DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
2 [WHERE where_condition]
3 [ORDER BY ...]
4 [LIMIT row_count]多表语法
Plain Text
1DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
2 tbl_name[.*] [, tbl_name[.*]] ...
3 FROM table_references
4 [WHERE where_condition]
5
6DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
7 FROM tbl_name[.*] [, tbl_name[.*]] ...
8 USING table_references
9 [WHERE where_condition]参考参考
MySQL DELETE语法。