1481 - MAXVALUE can only be used in last partition definition
MAXVALUE只能在最后一个分区定义中使用,表示新添加的分区不能在maxvalue之后,解决办法:
-
分区时不要添加maxValue
create table tb_users( uuid int not null, customerId varchar(20), password varchar(20), showName varchar(20), trueName varchar(100), registerTime varchar(100) ) partition by Range(uuid)( partition p0 values less than (5), partition p1 values less than (10), partition p2 values less than (15) );
这样创建分区会有问题,如图当uuid大于15的时候会报错。
-
重新分区
ALTER TABLE tb_users PARTITION by range(uuid)( partition p0 values less than(5), partition p1 values less than(10), partition p2 values less than(15), partition p3 values less than(30), partition p_default values less than maxvalue );