Rename Partition in Mysql Database
Example:
In this example I have renamed a single partition from P_2017_2 to P_2017_02
ALTER TABLE alarm.alarm_log
REORGANIZE PARTITION P_2017_2 INTO (
PARTITION P_2017_02 VALUES LESS THAN (1484521200)
);
In this example I have renamed multiple partitions.
ALTER TABLE alarm.alarm_log
REORGANIZE PARTITION P_2017_3,P_2017_4,P_2017_5,P_2017_6,P_2017_7,P_2017_8,P_2017_9 INTO (
PARTITION P_2017_03 VALUES LESS THAN (1485126000),
PARTITION P_2017_04 VALUES LESS THAN (1485730800),
PARTITION P_2017_05 VALUES LESS THAN (1486335600),
PARTITION P_2017_06 VALUES LESS THAN (1486940400),
PARTITION P_2017_07 VALUES LESS THAN (1487545200),
PARTITION P_2017_08 VALUES LESS THAN (1488150000),
PARTITION P_2017_09 VALUES LESS THAN (1488754800)
);