mysql 查看表的分区信息

SELECT PARTITION_NAME,TABLE_ROWS,PARTITION_EXPRESSION,PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='test' AND TABLE_NAME = 't11'; 查看某张表的分区名字，分区内行数，分区表达的列，分区范围