mysql 查看表的分区信息

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

posted @ 2019-01-03 14:17  Knight灬麒  阅读(7453)  评论(0编辑  收藏  举报