MySQL打算根據(jù)一個(gè)月31天來創(chuàng)建分區(qū),執(zhí)行代碼提示錯(cuò)誤,不知道是哪里有問題,有大佬解答一下嗎?ALTER TABLE `fastest`.`base_params_task_progress`?MODIFY COLUMN `tasktime` datetime NOT NULL COMMENT '任務(wù)時(shí)間' 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 );
MySQL創(chuàng)建分區(qū)錯(cuò)誤
E_mKs3178303
2020-05-10 14:06:52