mysql 分区

ALTER TABLE role_form_data_permit_map PARTITION BY KEY(id) PARTITIONS 5


SELECT PARTITION_NAME,TABLE_ROWS,PARTITION_EXPRESSION,PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 'role_form_func_permit_map'

posted @ 2020-09-16 20:37  applekingghfhfhbr  阅读(73)  评论(0编辑  收藏  举报