mysql 逻辑分区(字符串暂未支持)_MySQL
程序员文章站
2022-05-28 09:12:38
...
ALTER TABLE `aa_actor` PARTITION BY LIST(partition_id) (PARTITION `p0` VALUES IN ('a') , PARTITION `p1` VALUES IN ('s') , PARTITION `p2` VALUES IN ('d') , PARTITION `p3` VALUES IN ('f') , PARTITION `p4` VALUES IN ('0') , PARTITION `p5` VALUES IN ('6') , PARTITION `p6` VALUES IN ('g') , PARTITION `p7` VALUES IN ('x') , PARTITION `p8` VALUES IN ('v') , PARTITION `p9` VALUES IN ('b') ) ;