亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

MySQL創建分區錯誤

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 );
查看完整描述

目前暫無任何回答

  • 0 回答
  • 0 關注
  • 924 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號