对已存在的未分区的表进行分区
alter table test PARTITION BY RANGE(id)
(PARTITION p1 VALUES LESS THAN (101),PARTITION p2 VALUES LESS THAN (201) )
提示错误:
Table has no partition for value 201
原因是分区没有包含表中所有数据
即 如果表中最大id是1655,则改成:
alter table test PARTITION BY RANGE(id) (PARTITION p1 VALUES LESS THAN (1001),PARTITION p2 VALUES LESS THAN (2001) )
就好了(即所有数据都要有分区)