Delete水平分区

删除分区表和删除普通表一样，也可以指定子分区表删除数据。

示例：删除分区表

--  清理环境
DROP TABLE tab;

-- 创建分区表
CREATE TABLE tab 
(
    c1 INT, 
    c2 INT
)
PARTITION BY RANGE (c1)
(
    PARTITION p1 VALUES LESS THAN (10),
    PARTITION p2 VALUES LESS THAN (20),
    PARTITION p3 VALUES LESS THAN (30)
);

INSERT INTO tab VALUES(2,3);
INSERT INTO tab PARTITION(p2) VALUES(14, 20);
INSERT INTO tab VALUES(23, 12);
INSERT INTO tab VALUES(3,4);
INSERT INTO tab PARTITION(p2) VALUES(15, 23);
INSERT INTO tab VALUES(24, 32);

--和普通表一样删除数据
DELETE tab WHERE c1 = 3;

--从指定子分区表中删除复合条件的数据
DELETE tab PARTITION(p2) WHERE c1 = 15;

--删除表
drop table tab;