使用限制

当前只支持唯一键（Unique Key）表，对于其他场景请参考删除操作（DELETE）。

语法

DELETE FROM [db.]table WHERE expr;

示例

DELETE FROM musics WHERE Title LIKE '%hello%';

DROP PARTITION 命令删除分区，参考如下：

# 如果分区为该类型：PARTITION BY x
ALTER TABLE t DROP PARTITION '2009-08-01',

# 如果分区为该类型：PARTITION BY toYYYYMMDD(toDate(x))
ALTER TABLE t DROP PARTITION WHERE `toYYYYMMDD(toDate(x))` = toYYYYMMDD(yesterday());

# 如果分区为该类型：PARTITION BY toYYYYMMDD(toDateTime(x))
ALTER TABLE t DROP PARTITION WHERE `toYYYYMMDD(toDateTime(x))` = toYYYYMMDD(yesterday());

# 如果分区为该类型：PARTITION BY toDate(x)
ALTER TABLE t DROP PARTITION WHERE `toDate(x)` = yesterday();