ALTER TABLE `XXXXX` PARTITION BY RANGE COLUMNS(created_at) ( PARTITION p201412 VALUES LESS THAN ('2015-01-01') ENGINE=InnoDB, PARTITION p201501 VALUES LESS THAN ('2015-02-01') ENGINE=InnoDB, PARTITION p201502 VALUES LESS THAN ('2015-03-01') ENGINE=InnoDB, PARTITION p201503 VALUES LESS THAN ('2015-04-01') ENGINE=InnoDB, PARTITION p201504 VALUES LESS THAN ('2015-05-01') ENGINE=InnoDB, PARTITION p201