mysql 扩展分区

话务分区表，按季度分区， 18年分了72个分区，领导问18年后怎么办？

答：在继续追加分区即可

p_max为你最后一个分区表

ALTER table cti_acd_event REORGANIZE PARTITION p_max INTO 
(PARTITION p_2037_03 VALUES LESS THAN (TO_DAYS('2037-03-01')),
PARTITION p_2037_06 VALUES LESS THAN (TO_DAYS('2037-06-01')),
PARTITION p_2037_09 VALUES LESS THAN (TO_DAYS('2037-09-01')),
PARTITION p_2037_12 VALUES LESS THAN (TO_DAYS('2037-12-01')),

PARTITION p_max VALUES LESS THAN MAXVALUE);

mysql 5.7.29