DELETE

语法概要

DELETE FROM table_name [ WHERE condition ]

说明

从表中删除行。如果指定 WHERE 子句,则只删除匹配的行;否则删除表中的所有行。

示例

删除所有通过空运发货的明细项:

DELETE FROM lineitem WHERE shipmode = 'AIR';

删除所有订单:

DELETE FROM orders;