SQL DELETE 语句

DELETE 语句用于删除表中的记录。

以菜鸟教程上的Websites表为例

+----+--------------+---------------------------+-------+---------+
| id | name         | url                       | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1  | Google       | https://www.google.cm/    | 1     | USA     |
| 2  | 淘宝       | https://www.taobao.com/   | 13    | CN      |
| 3  | 菜鸟教程 | http://www.runoob.com/    | 4689  | CN      |
| 4  | 微博       | http://weibo.com/         | 20    | CN      |
| 5  | Facebook     | https://www.facebook.com/ | 3     | USA     |
+----+--------------+---------------------------+-------+---------+

// 删除FaceBook这行数据

DELETE FROM Websites
WHERE name='Facebook' AND country='USA';

DELETE FROM Websites
WHERE id='5';

// 删除整张表

DELETE FROM Websites

缺少WHERE 语句，默认是全表操作。

DELETE * FROM Websites