mysql-partitioning.sql

ALTER TABLE `transaction` 
PARTITION BY RANGE(TO_DAYS(created_time))
(PARTITION p09xx VALUES LESS THAN (TO_DAYS('2010-01-01')),
PARTITION p1001 VALUES LESS THAN (TO_DAYS('2010-02-01')),
PARTITION p1002 VALUES LESS THAN (TO_DAYS('2010-03-01')),
PARTITION p1003 VALUES LESS THAN (TO_DAYS('2010-04-01')),
PARTITION p1004 VALUES LESS THAN (TO_DAYS('2010-05-01')),
PARTITION p1005 VALUES LESS THAN (TO_DAYS('2010-06-01')),
PARTITION p1006 VALUES LESS THAN (TO_DAYS('2010-07-01')),
PARTITION p1007 VALUES LESS THAN (TO_DAYS('2010-08-01')),
PARTITION p1008 VALUES LESS THAN (TO_DAYS('2010-09-01')),
PARTITION p1009 VALUES LESS THAN (TO_DAYS('2010-10-01')),
PARTITION p1010 VALUES LESS THAN (TO_DAYS('2010-11-01')),
PARTITION p1011 VALUES LESS THAN (TO_DAYS('2010-12-01')),
PARTITION p1012 VALUES LESS THAN (TO_DAYS('2011-01-01')),
PARTITION p1101 VALUES LESS THAN (TO_DAYS('2011-02-01')),
PARTITION p1102 VALUES LESS THAN (TO_DAYS('2011-03-01')),
PARTITION p1103 VALUES LESS THAN (TO_DAYS('2011-04-01')),
PARTITION p1104 VALUES LESS THAN (TO_DAYS('2011-05-01')),
PARTITION p1105 VALUES LESS THAN (TO_DAYS('2011-06-01')),
PARTITION p1106 VALUES LESS THAN (TO_DAYS('2011-07-01')),
PARTITION p1107 VALUES LESS THAN (TO_DAYS('2011-08-01')),
PARTITION p1108 VALUES LESS THAN (TO_DAYS('2011-09-01')),
PARTITION p1109 VALUES LESS THAN (TO_DAYS('2011-10-01')),
PARTITION p1110 VALUES LESS THAN (TO_DAYS('2011-11-01')),
PARTITION p1111 VALUES LESS THAN (TO_DAYS('2011-12-01')),
PARTITION p1112 VALUES LESS THAN (TO_DAYS('2012-01-01')),
PARTITION p1201 VALUES LESS THAN (TO_DAYS('2012-02-01')),
PARTITION p1202 VALUES LESS THAN (TO_DAYS('2012-03-01')),
PARTITION p1203 VALUES LESS THAN (TO_DAYS('2012-04-01')),
PARTITION p1204 VALUES LESS THAN (TO_DAYS('2012-05-01')),
PARTITION p1205 VALUES LESS THAN (TO_DAYS('2012-06-01')),
PARTITION p1206 VALUES LESS THAN (TO_DAYS('2012-07-01')),
PARTITION p1207 VALUES LESS THAN (TO_DAYS('2012-08-01')),
PARTITION p1208 VALUES LESS THAN (TO_DAYS('2012-09-01')),
PARTITION p1209 VALUES LESS THAN (TO_DAYS('2012-10-01')),
PARTITION p1210 VALUES LESS THAN (TO_DAYS('2012-11-01')),
PARTITION p1211 VALUES LESS THAN (TO_DAYS('2012-12-01')),
PARTITION p1212 VALUES LESS THAN (TO_DAYS('2013-01-01')));