MYSQL追加表分区问题

如果在追加表分区失败其中有一个原因是：在原分区中设置了最大值分区，需要将其删除后才能进行按序追加。

如：原分区为：

ALTER TABLE ef_areas_month PARTITION BY RANGE COLUMNS(months)(
 PARTITION M01 VALUES LESS THAN ('201901'),
 PARTITION M02 VALUES LESS THAN ('201902'),
 PARTITION M03 VALUES LESS THAN ('201903'),
 PARTITION M04 VALUES LESS THAN ('201904'),
 PARTITION M05 VALUES LESS THAN ('201905'),
 PARTITION M06 VALUES LESS THAN ('201906'),
 PARTITION M07 VALUES LESS THAN ('201907'),
 PARTITION M08 VALUES LESS THAN ('201908'),
 PARTITION M09 VALUES LESS THAN ('201909'),
 PARTITION M10 VALUES LESS THAN ('201910'),
 PARTITION M11 VALUES LESS THAN ('201911'),
 PARTITION M12 VALUES LESS THAN ('201912'),
 PARTITION M13 VALUES LESS THAN ('202001'),
 PARTITION MMAX VALUES LESS THAN MAXVALUE
 );

如果想再后面顺序追加分区则需要删除MMAX的分区才能往后追加。

 ALTER TABLE ef_areas_fixmonth DROP PARTITION MMAX;  -- 如果有MAXVALUE分区，则将其删除后再追加分区
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M14 VALUES LESS THAN ('202002'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M15 VALUES LESS THAN ('202003'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M16 VALUES LESS THAN ('202004'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M17 VALUES LESS THAN ('202005'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M18 VALUES LESS THAN ('202006'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M19 VALUES LESS THAN ('202007'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M20 VALUES LESS THAN ('202008'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M21 VALUES LESS THAN ('202009'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M22 VALUES LESS THAN ('202010'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M23 VALUES LESS THAN ('202011'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M24 VALUES LESS THAN ('202012'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION M25 VALUES LESS THAN ('202101'));
 ALTER TABLE ef_areas_fixmonth ADD PARTITION (PARTITION MMAX VALUES LESS THAN (MAXVALUE));