SELECT
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
FROM
INFORMATION_SCHEMA.partitions
WHERE
TABLE_SCHEMA = schema()
AND TABLE_NAME='table';
转自 http://www.cnblogs.com/licous/p/3863691.html
阅读(3328) | 评论(0) | 转发(0) |
