删除你的数据

将 SQL 应用于真实问题

Dmitriy (Dima) Gorenshteyn

Lead Data Scientist, Memorial Sloan Kettering Cancer Center

DROP、TRUNCATE、DELETE

移除一张表

DROP TABLE table_name;

清空表中所有记录

TRUNCATE TABLE table_name;

删除表中部分记录

DELETE FROM table_name WHERE condition;

目标修改： 删除不再活跃的客户

DELETE FROM customer
WHERE active = FALSE;

目标修改： 删除居住在 Woodridge 市的所有客户。

DELETE FROM customer
WHERE address_id IN 
  (SELECT address_id 
   FROM address
   WHERE city = 'Woodridge');

将 SQL 应用于真实问题