ALTER TABLE news PARTITION by range(news_id)
(
PARTITION news_a VALUES less THAN(4),
PARTITION news_b VALUES Less THAN(6),
PARTITION news_c VALUES Less than(MAXVALUE)
);
#合并分区
ALTER TABLE news REORGANIZE PARTITION news_a,news_b INTO (PARTITION news_d VALUES less than(6));
#删除分区不丢失数据
ALTER TABLE news REMOVE PARTITIONING;
#删除丢失数据
ALTER TABLE news DROP PARTITION news_a;
#查询分区
EXPLAIN PARTITIONS SELECT * FROM news;
(
PARTITION news_a VALUES less THAN(4),
PARTITION news_b VALUES Less THAN(6),
PARTITION news_c VALUES Less than(MAXVALUE)
);
#合并分区
ALTER TABLE news REORGANIZE PARTITION news_a,news_b INTO (PARTITION news_d VALUES less than(6));
#删除分区不丢失数据
ALTER TABLE news REMOVE PARTITIONING;
#删除丢失数据
ALTER TABLE news DROP PARTITION news_a;
#查询分区
EXPLAIN PARTITIONS SELECT * FROM news;