数据库报错没有分区Table has no partition for value，创建表分区失败

没有定义20231001以后的日期分区。

向北向北向北swag*

1502人浏览 · 2023-10-05 22:46:38

向北向北向北swag* · 2023-10-05 22:46:38 发布

Table has no partition for value 20231005
创建分区失败
查看分区
select * from INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = ’ ’ ORDER BY partition_ordinal_position asc ;
查看创建表语句
PARTITION BY RANGE (order_date)
(PARTITION ** VALUES LESS THAN (20231001) ENGINE = InnoDB) */;

没有定义20231001以后的日期分区

改成
PARTITION BY RANGE (order_date)
(PARTITION ** VALUES LESS THAN (20241001) ENGINE = InnoDB)