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 );
添加回答
举报
0/150
提交
取消