删除

语法

DELETE FROM table_name
WHERE predicate [AND predicate ...];

规则

• WHERE 是必需的。不带 WHERE 子句的 DELETE 将被解析器拒绝。

• 谓词仅通过 AND 组合。

示例

删除特定行：

DELETE FROM new_order
WHERE no_w_id = 1 AND no_d_id = 2 AND no_o_id = 100;

使用占位符删除：

DELETE FROM history
WHERE h_c_id = ? AND h_c_d_id = ? AND h_c_w_id = ?;