添加分区
alter table t_partion_test add PARTITION( PARTITION p_max values less than maxvalue) ;
拆分区
ALTER TABLE t_partion_test REORGANIZE PARTITION p_max INTO (
PARTITION p6 VALUES LESS THAN (60000),
PARTITION p_max values less than maxvalue
);
用表交换分区
ALTER TABLE t_partion_test EXCHANGE PARTITION p6 WITH TABLE t_nopartion_test;
truncate分区
alter table t_partion_test TRUNCATE PARTITION p6 ;
删除分区
alter table t_partion_test drop PARTITION p0 ;