分区的sql语句:
partition BY RANGE (store_id) (
partition p0 VALUES LESS THAN (6),
partition p1 VALUES LESS THAN (11),
partition p2 VALUES LESS THAN (16),
partition p3 VALUES LESS THAN (21),
PARTITION p4 VALUES LESS THAN MAXVALUE
);
删除分区
alter table user drop partition p4;
新增分区
alter table user add partition(partition p4 values less than MAXVALUE);
MySQL分区相关sql语法
最新推荐文章于 2024-07-24 22:36:05 发布