刪除你的資料

將 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 應用於真實世界問題