SELECT PARTITION_NAME,TABLE_ROWS,PARTITION_EXPRESSION,PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA=‘test’ AND TABLE_NAME = ‘t11’; 查看某张表的分区名字,分区内行数,分区表达的列,分区范围
mysql 查看表的分区信息
最新推荐文章于 2024-01-05 20:16:39 发布
SELECT PARTITION_NAME,TABLE_ROWS,PARTITION_EXPRESSION,PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA=‘test’ AND TABLE_NAME = ‘t11’; 查看某张表的分区名字,分区内行数,分区表达的列,分区范围