DELETE¶ 语法概要¶ DELETE FROM table_name [ WHERE condition ] 说明¶ 从表中删除行。如果指定 WHERE 子句,则只删除匹配的行;否则删除表中的所有行。 示例¶ 删除所有通过空运发货的明细项: DELETE FROM lineitem WHERE shipmode = 'AIR'; 删除所有订单: DELETE FROM orders;