跳转至

SQL DELETE

DELETE 用于删除表中的记录。

基本语法

DELETE FROM table_name
WHERE condition;

示例

DELETE FROM users
WHERE id = 3;

风险提示

如果没有 WHERE，会删除整张表中的所有记录：

DELETE FROM users;

DELETE 与 DROP

  • DELETE 删除的是表中的数据。
  • DROP TABLE 删除的是整张表结构及其数据。

相关链接