DELETE语法用来删除表中的行数据,可指定过滤条件。

语法

DELETE FROM table_name WHERE where_clause;

示例

DELETE FROM dt WHERE p1 = 10 AND p2 = 20;
DELETE FROM dt WHERE p1 > 10;