猿问
下载APP

MySQL创建分区错误

MySQL打算根据一个月31天来创建分区,执行代码提示错误,不知道是哪里有问题,有大佬解答一下吗?

ALTER TABLE `fastest`.`base_params_task_progress` 

MODIFY COLUMN `tasktime` datetime NOT NULL COMMENT '任务时间' AFTER `type`,

DROP PRIMARY KEY,

ADD PRIMARY KEY (`id`, `tasktime`) USING BTREE,

ADD INDEX `tasktime`(`tasktime`) USING BTREE, PARTITION BY RANGE (DAY(tasktime))

PARTITIONS 31

(PARTITION `p0` VALUES LESS THAN (1) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p1` VALUES LESS THAN (2) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p11` VALUES LESS THAN (2) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p2` VALUES LESS THAN (3) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p3` VALUES LESS THAN (4) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p4` VALUES LESS THAN (5) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p5` VALUES LESS THAN (6) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p6` VALUES LESS THAN (7) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p7` VALUES LESS THAN (8) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p27` VALUES LESS THAN (8) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p8` VALUES LESS THAN (9) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p9` VALUES LESS THAN (10) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p10` VALUES LESS THAN (11) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p12` VALUES LESS THAN (13) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p13` VALUES LESS THAN (14) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p14` VALUES LESS THAN (15) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p15` VALUES LESS THAN (16) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p16` VALUES LESS THAN (17) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p17` VALUES LESS THAN (18) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p18` VALUES LESS THAN (19) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p19` VALUES LESS THAN (20) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p20` VALUES LESS THAN (21) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p21` VALUES LESS THAN (22) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p22` VALUES LESS THAN (23) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p23` VALUES LESS THAN (24) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p24` VALUES LESS THAN (25) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p25` VALUES LESS THAN (26) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p26` VALUES LESS THAN (27) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p28` VALUES LESS THAN (29) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p29` VALUES LESS THAN (30) MAX_ROWS = 0 MIN_ROWS = 0 ,

PARTITION `p30` VALUES LESS THAN (31) MAX_ROWS = 0 MIN_ROWS = 0 );

http://img4.mukewang.com/5eb7998e000197c810430195.jpg

E_mKs3178303
浏览 318回答 0
0回答
打开App,查看更多内容
随时随地看视频慕课网APP
我要回答
继续浏览精彩内容
慕课网APP
程序员的梦工厂
继续