mysql无法创建partition_mysql分区创建不成功

本帖最后由 bssb8 于 2016-8-5 15:12 编辑

CREATE TABLE `tbl_push_record` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',

`message_type` char(1) NOT NULL COMMENT '消息类型,0:素材1:内网通知2:事项',

`source_id` int(20) DEFAULT NULL COMMENT '消息源id(素材id/涉税事项id/内网通知id)',

`pushNum` int(20) DEFAULT NULL COMMENT '推送数',

`receiver_type` char(1) DEFAULT NULL COMMENT '接收者类型',

`message_json` varchar(2000) DEFAULT NULL COMMENT '消息json串',

`action` char(1) DEFAULT NULL COMMENT '有效标识0:无效，1：有效',

`browseNum` int(20) DEFAULT NULL COMMENT '浏览次数',

`shareNum` int(20) DEFAULT NULL COMMENT '分享次数',

`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8

PARTITION BY RANGE(create_time) (

PARTITION p1 VALUES LESS THAN (20160701),

PARTITION p2 VALUES LESS THAN (20160801),

PARTITION p3 VALUES LESS THAN (20160901),

PARTITION p4 VALUES LESS THAN (20161001),

PARTITION p5 VALUES LESS THAN (20161101),

PARTITION p6 VALUES LESS THAN (20161201),

PARTITION p7 VALUES LESS THAN (20170101),

PARTITION p8 VALUES LESS THAN (20170201),

PARTITION p9 VALUES LESS THAN (20170301),

PARTITION p10 VALUES LESS THAN (20170401),

PARTITION p11 VALUES LESS THAN (20170501),

PARTITION p12 VALUES LESS THAN (20170601),

PARTITION p13 VALUES LESS THAN (20170701),

PARTITION p14 VALUES LESS THAN (20170801),

PARTITION p15 VALUES LESS THAN (20170901),

PARTITION p16 VALUES LESS THAN (20171001),

PARTITION p17 VALUES LESS THAN (20171101),

PARTITION p18 VALUES LESS THAN (20171201),

PARTITION p19 VALUES LESS THAN (20180101),

PARTITION p20 VALUES LESS THAN (20180201),

PARTITION p21 VALUES LESS THAN (20180301),

PARTITION p22 VALUES LESS THAN (20180401),

PARTITION p23 VALUES LESS THAN (20180501),

PARTITION pm VALUES LESS THAN MAXVALUE);