3.2.03_DELETE.md

3.2.3 DELETE

3.2.3.1 Syntax

DELETE [IGNORE]

FROM tbl_name [WHERE where_condition]

3.2.3.2 举例

delete from test where id>5;

3.2.3.3 限制

• Delete语句中的where_condition部分只允许出现简单的条件，不能支持计算表达式以及子查询
• 不支持多表Join 的DELETE