mysql分区不够用时添加分区

range分区的片需要连续,所以添加时需要先把之前的p9999删掉,在按时间顺序添加,下面是目前使用的建表语句

CREATE TABLE `t_machine_alert_gantt` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `machine_id` int(11) NOT NULL COMMENT '机器id',
  `msg_code` int(11) NOT NULL COMMENT '信息code',
  `start_time` datetime(3) NOT NULL COMMENT '开始时间戳',
  `end_time` datetime(3) DEFAULT NULL COMMENT '结束时间戳',
  PRIMARY KEY (`id`,`machine_id`,`start_time`) USING BTREE,
  KEY `index_time` (`start_time`) USING BTREE,
  KEY `mid_code_index` (`machine_id`,`msg_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='机器故障表'
/*!50500 PARTITION BY RANGE  COLUMNS(start_time)
(PARTITION p101 VALUES LESS THAN ('2019-01-01') ENGINE = InnoDB,
 PARTITION p102 VALUES LESS THAN ('2019-02-01') ENGINE = InnoDB,
 PARTITION p103 VALUES LESS THAN ('2019-03-01') ENGINE = InnoDB,
 PARTITION p104 VALUES LESS THAN ('2019-04-01') ENGINE = InnoDB,
 PARTITION p105 VALUES LESS THAN ('2019-05-01') ENGINE = InnoDB,
 PARTITION p106 VALUES LESS THAN ('2019-06-01') ENGINE = InnoDB,
 PARTITION p107 VALUES LESS THAN ('2019-07-01') ENGINE = InnoDB,
 PARTITION p108 VALUES LESS THAN ('2019-08-01') ENGINE = InnoDB,
 PARTITION p109 VALUES LESS THAN ('2019-09-01') ENGINE = InnoDB,
 PARTITION p10A VALUES LESS THAN ('2019-10-01') ENGINE = InnoDB,
 PARTITION p10B VALUES LESS THAN ('2019-11-01') ENGINE = InnoDB,
 PARTITION p10C VALUES LESS THAN ('2019-12-01') ENGINE = InnoDB,
 PARTITION p111 VALUES LESS THAN ('2020-01-01') ENGINE = InnoDB,
 PARTITION p112 VALUES LESS THAN ('2020-02-01') ENGINE = InnoDB,
 PARTITION p113 VALUES LESS THAN ('2020-03-01') ENGINE = InnoDB,
 PARTITION p114 VALUES LESS THAN ('2020-04-01') ENGINE = InnoDB,
 PARTITION p115 VALUES LESS THAN ('2020-05-01') ENGINE = InnoDB,
 PARTITION p116 VALUES LESS THAN ('2020-06-01') ENGINE = InnoDB,
 PARTITION p117 VALUES LESS THAN ('2020-07-01') ENGINE = InnoDB,
 PARTITION p118 VALUES LESS THAN ('2020-08-01') ENGINE = InnoDB,
 PARTITION p119 VALUES LESS THAN ('2020-09-01') ENGINE = InnoDB,
 PARTITION p11A VALUES LESS THAN ('2020-10-01') ENGINE = InnoDB,
 PARTITION p11B VALUES LESS THAN ('2020-11-01') ENGINE = InnoDB,
 PARTITION p11C VALUES LESS THAN ('2020-12-01') ENGINE = InnoDB,
 PARTITION p121 VALUES LESS THAN ('2021-01-01') ENGINE = InnoDB,
 PARTITION p122 VALUES LESS THAN ('2021-02-01') ENGINE = InnoDB,
 PARTITION p123 VALUES LESS THAN ('2021-03-01') ENGINE = InnoDB,
 PARTITION p124 VALUES LESS THAN ('2021-04-01') ENGINE = InnoDB,
 PARTITION p125 VALUES LESS THAN ('2021-05-01') ENGINE = InnoDB,
 PARTITION p126 VALUES LESS THAN ('2021-06-01') ENGINE = InnoDB,
 PARTITION p127 VALUES LESS THAN ('2021-07-01') ENGINE = InnoDB,
 PARTITION p128 VALUES LESS THAN ('2021-08-01') ENGINE = InnoDB,
 PARTITION p129 VALUES LESS THAN ('2021-09-01') ENGINE = InnoDB,
 PARTITION p12A VALUES LESS THAN ('2021-10-01') ENGINE = InnoDB,
 PARTITION p12B VALUES LESS THAN ('2021-11-01') ENGINE = InnoDB,
 PARTITION p12C VALUES LESS THAN ('2021-12-01') ENGINE = InnoDB,
 PARTITION p131 VALUES LESS THAN ('2022-01-01') ENGINE = InnoDB,
 PARTITION p132 VALUES LESS THAN ('2022-02-01') ENGINE = InnoDB,
 PARTITION p133 VALUES LESS THAN ('2022-03-01') ENGINE = InnoDB,
 PARTITION p134 VALUES LESS THAN ('2022-04-01') ENGINE = InnoDB,
 PARTITION p135 VALUES LESS THAN ('2022-05-01') ENGINE = InnoDB,
 PARTITION p136 VALUES LESS THAN ('2022-06-01') ENGINE = InnoDB,
 PARTITION p137 VALUES LESS THAN ('2022-07-01') ENGINE = InnoDB,
 PARTITION p138 VALUES LESS THAN ('2022-08-01') ENGINE = InnoDB,
 PARTITION p139 VALUES LESS THAN ('2022-09-01') ENGINE = InnoDB,
 PARTITION p13A VALUES LESS THAN ('2022-10-01') ENGINE = InnoDB,
 PARTITION p13B VALUES LESS THAN ('2022-11-01') ENGINE = InnoDB,
 PARTITION p13C VALUES LESS THAN ('2022-12-01') ENGINE = InnoDB,
 PARTITION p141 VALUES LESS THAN ('2023-01-01') ENGINE = InnoDB,
 PARTITION p142 VALUES LESS THAN ('2023-02-01') ENGINE = InnoDB,
 PARTITION p143 VALUES LESS THAN ('2023-03-01') ENGINE = InnoDB,
 PARTITION p144 VALUES LESS THAN ('2023-04-01') ENGINE = InnoDB,
 PARTITION p145 VALUES LESS THAN ('2023-05-01') ENGINE = InnoDB,
 PARTITION p146 VALUES LESS THAN ('2023-06-01') ENGINE = InnoDB,
 PARTITION p147 VALUES LESS THAN ('2023-07-01') ENGINE = InnoDB,
 PARTITION p148 VALUES LESS THAN ('2023-08-01') ENGINE = InnoDB,
 PARTITION p149 VALUES LESS THAN ('2023-09-01') ENGINE = InnoDB,
 PARTITION p14A VALUES LESS THAN ('2023-10-01') ENGINE = InnoDB,
 PARTITION p14B VALUES LESS THAN ('2023-11-01') ENGINE = InnoDB,
 PARTITION p14C VALUES LESS THAN ('2023-12-01') ENGINE = InnoDB,
 PARTITION p9999 VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB) */;

添加分区操作

删除p9999分区

alter table t_machine_alert_gantt drop partition p9999;

添加新分区(分区名称按照p001-p00c命名,一年12个月;分区内数据存储的是比当前时间范围小的数据)

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p151 VALUES LESS THAN ('2024-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p152 VALUES LESS THAN ('2024-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p153 VALUES LESS THAN ('2024-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p154 VALUES LESS THAN ('2024-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p155 VALUES LESS THAN ('2024-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p156 VALUES LESS THAN ('2024-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p157 VALUES LESS THAN ('2024-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p158 VALUES LESS THAN ('2024-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p159 VALUES LESS THAN ('2024-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p15A VALUES LESS THAN ('2024-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p15B VALUES LESS THAN ('2024-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p15C VALUES LESS THAN ('2024-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p161 VALUES LESS THAN ('2025-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p162 VALUES LESS THAN ('2025-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p163 VALUES LESS THAN ('2025-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p164 VALUES LESS THAN ('2025-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p165 VALUES LESS THAN ('2025-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p166 VALUES LESS THAN ('2025-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p167 VALUES LESS THAN ('2025-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p168 VALUES LESS THAN ('2025-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p169 VALUES LESS THAN ('2025-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p16A VALUES LESS THAN ('2025-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p16B VALUES LESS THAN ('2025-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p16C VALUES LESS THAN ('2025-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p171 VALUES LESS THAN ('2026-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p172 VALUES LESS THAN ('2026-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p173 VALUES LESS THAN ('2026-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p174 VALUES LESS THAN ('2026-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p175 VALUES LESS THAN ('2026-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p176 VALUES LESS THAN ('2026-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p177 VALUES LESS THAN ('2026-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p178 VALUES LESS THAN ('2026-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p179 VALUES LESS THAN ('2026-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p17A VALUES LESS THAN ('2026-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p17B VALUES LESS THAN ('2026-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p17C VALUES LESS THAN ('2026-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p181 VALUES LESS THAN ('2027-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p182 VALUES LESS THAN ('2027-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p183 VALUES LESS THAN ('2027-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p184 VALUES LESS THAN ('2027-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p185 VALUES LESS THAN ('2027-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p186 VALUES LESS THAN ('2027-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p187 VALUES LESS THAN ('2027-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p188 VALUES LESS THAN ('2027-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p189 VALUES LESS THAN ('2027-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p18A VALUES LESS THAN ('2027-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p18B VALUES LESS THAN ('2027-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p18C VALUES LESS THAN ('2027-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p191 VALUES LESS THAN ('2028-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p192 VALUES LESS THAN ('2028-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p193 VALUES LESS THAN ('2028-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p194 VALUES LESS THAN ('2028-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p195 VALUES LESS THAN ('2028-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p196 VALUES LESS THAN ('2028-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p197 VALUES LESS THAN ('2028-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p198 VALUES LESS THAN ('2028-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p199 VALUES LESS THAN ('2028-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p19A VALUES LESS THAN ('2028-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p19B VALUES LESS THAN ('2028-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p19C VALUES LESS THAN ('2028-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p201 VALUES LESS THAN ('2029-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p202 VALUES LESS THAN ('2029-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p203 VALUES LESS THAN ('2029-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p204 VALUES LESS THAN ('2029-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p205 VALUES LESS THAN ('2029-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p206 VALUES LESS THAN ('2029-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p207 VALUES LESS THAN ('2029-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p208 VALUES LESS THAN ('2029-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p209 VALUES LESS THAN ('2029-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p20A VALUES LESS THAN ('2029-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p20B VALUES LESS THAN ('2029-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p20C VALUES LESS THAN ('2029-12-01') ENGINE = InnoDB);

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p211 VALUES LESS THAN ('2030-01-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p212 VALUES LESS THAN ('2030-02-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p213 VALUES LESS THAN ('2030-03-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p214 VALUES LESS THAN ('2030-04-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p215 VALUES LESS THAN ('2030-05-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p216 VALUES LESS THAN ('2030-06-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p217 VALUES LESS THAN ('2030-07-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p218 VALUES LESS THAN ('2030-08-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p219 VALUES LESS THAN ('2030-09-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p21A VALUES LESS THAN ('2030-10-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p21B VALUES LESS THAN ('2030-11-01') ENGINE = InnoDB);
ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p21C VALUES LESS THAN ('2030-12-01') ENGINE = InnoDB);

添加回p9999分区(安全考虑)

ALTER TABLE t_machine_alert_gantt ADD PARTITION (PARTITION p9999 VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB);

这里面还有个t_parts_warn_log,表分区不是按照正常来的,他没有p9999这个最大值分区,所以得这样加

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p161 VALUES LESS THAN ('2025-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p162 VALUES LESS THAN ('2025-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p163 VALUES LESS THAN ('2025-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p164 VALUES LESS THAN ('2025-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p165 VALUES LESS THAN ('2025-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p166 VALUES LESS THAN ('2025-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p167 VALUES LESS THAN ('2025-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p168 VALUES LESS THAN ('2025-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p169 VALUES LESS THAN ('2025-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p16A VALUES LESS THAN ('2025-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p16B VALUES LESS THAN ('2025-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p16C VALUES LESS THAN ('2025-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p171 VALUES LESS THAN ('2026-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p172 VALUES LESS THAN ('2026-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p173 VALUES LESS THAN ('2026-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p174 VALUES LESS THAN ('2026-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p175 VALUES LESS THAN ('2026-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p176 VALUES LESS THAN ('2026-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p177 VALUES LESS THAN ('2026-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p178 VALUES LESS THAN ('2026-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p179 VALUES LESS THAN ('2026-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p17A VALUES LESS THAN ('2026-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p17B VALUES LESS THAN ('2026-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p17C VALUES LESS THAN ('2026-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p181 VALUES LESS THAN ('2027-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p182 VALUES LESS THAN ('2027-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p183 VALUES LESS THAN ('2027-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p184 VALUES LESS THAN ('2027-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p185 VALUES LESS THAN ('2027-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p186 VALUES LESS THAN ('2027-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p187 VALUES LESS THAN ('2027-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p188 VALUES LESS THAN ('2027-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p189 VALUES LESS THAN ('2027-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p18A VALUES LESS THAN ('2027-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p18B VALUES LESS THAN ('2027-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p18C VALUES LESS THAN ('2027-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p191 VALUES LESS THAN ('2028-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p192 VALUES LESS THAN ('2028-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p193 VALUES LESS THAN ('2028-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p194 VALUES LESS THAN ('2028-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p195 VALUES LESS THAN ('2028-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p196 VALUES LESS THAN ('2028-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p197 VALUES LESS THAN ('2028-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p198 VALUES LESS THAN ('2028-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p199 VALUES LESS THAN ('2028-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p19A VALUES LESS THAN ('2028-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p19B VALUES LESS THAN ('2028-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p19C VALUES LESS THAN ('2028-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p201 VALUES LESS THAN ('2029-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p202 VALUES LESS THAN ('2029-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p203 VALUES LESS THAN ('2029-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p204 VALUES LESS THAN ('2029-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p205 VALUES LESS THAN ('2029-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p206 VALUES LESS THAN ('2029-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p207 VALUES LESS THAN ('2029-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p208 VALUES LESS THAN ('2029-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p209 VALUES LESS THAN ('2029-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p20A VALUES LESS THAN ('2029-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p20B VALUES LESS THAN ('2029-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p20C VALUES LESS THAN ('2029-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p211 VALUES LESS THAN ('2030-01-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p212 VALUES LESS THAN ('2030-02-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p213 VALUES LESS THAN ('2030-03-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p214 VALUES LESS THAN ('2030-04-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p215 VALUES LESS THAN ('2030-05-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p216 VALUES LESS THAN ('2030-06-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p217 VALUES LESS THAN ('2030-07-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p218 VALUES LESS THAN ('2030-08-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p219 VALUES LESS THAN ('2030-09-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p21A VALUES LESS THAN ('2030-10-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p21B VALUES LESS THAN ('2030-11-01') ENGINE = InnoDB);
ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p21C VALUES LESS THAN ('2030-12-01') ENGINE = InnoDB);

ALTER TABLE t_parts_warn_log ADD PARTITION (PARTITION p9999 VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB);

posted @ 2023-08-10 09:06 ForLivetoLearn 阅读(10) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

奋斗

mysql分区不够用时添加分区

公告