mysql分区常见操作

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;