Delete 语句

Delete 语句用于删除表中已有的记录。

可以使用带有 Where 子句的 Delete 语句删除选定的行，否则所有记录都会被删除。

删除所有行

语法

DELETE FROM TABLE_NAME;

实例

DELETE FROM customers;

删除指定行

语法

DELETE FROM TABLE_NAME
WHERE condition;

实例

DELETE FROM customers
WHERE id = 1;