DELETE¶

概要¶

DELETE FROM table_name [ WHERE condition ]

從表格中刪除列。如果指定 WHERE 子句，則僅刪除符合的列。否則，將刪除表格中的所有列。

刪除所有空運的行項目

DELETE FROM lineitem WHERE shipmode = 'AIR';

刪除所有低優先級訂單的行項目

DELETE FROM lineitem
WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');

刪除所有訂單

DELETE FROM orders;

某些連接器對 DELETE 的支援有限或沒有支援。請參閱連接器文件以取得更多詳細資訊。