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 );
|
天盟APP下载
