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

results matching ""

    No results matching ""