比如,我按照月份来分区,一直建立到7月份,以后还要不断分出8月,9月 ...长此以往!以后该如何追加分区呢?ALTER TABLE E_info PARTITION BY RANGE(time DIV 100)
(
PARTITION p_2008_11 VALUES LESS THAN (200812),
PARTITION p_2008_12 VALUES LESS THAN (200901),
PARTITION p_2009_01 VALUES LESS THAN (200902),
PARTITION p_2009_02 VALUES LESS THAN (200903),
PARTITION p_2009_03 VALUES LESS THAN (200904),
PARTITION p_2009_04 VALUES LESS THAN (200905),
PARTITION p_2009_05 VALUES LESS THAN (200906),
PARTITION p_2009_06 VALUES LESS THAN (200907),
PARTITION p_2009_07 VALUES LESS THAN (200908),
PARTITION p_catch_all VALUES LESS THAN MAXVALUE
);
(
PARTITION p_2008_11 VALUES LESS THAN (200812),
PARTITION p_2008_12 VALUES LESS THAN (200901),
PARTITION p_2009_01 VALUES LESS THAN (200902),
PARTITION p_2009_02 VALUES LESS THAN (200903),
PARTITION p_2009_03 VALUES LESS THAN (200904),
PARTITION p_2009_04 VALUES LESS THAN (200905),
PARTITION p_2009_05 VALUES LESS THAN (200906),
PARTITION p_2009_06 VALUES LESS THAN (200907),
PARTITION p_2009_07 VALUES LESS THAN (200908),
PARTITION p_catch_all VALUES LESS THAN MAXVALUE
);
(partition p_2009_08 values less than (200909),
partition p_catch_all values less than maxvalue
)