Question

mysql RANGE 字符串字段怎么分区

mysql 怎么用varchar字段进行分区

Answer 1

若设置了 LESS THAN MAXVALUE分区，添加新分区时，需要重新分区。
/*重新定义range分区表:*/
Alter table emp partition by range(salary)
(
partition p1 values less than (2000),
partition p2 values less than (4000)