> 文档中心 > mysql查看表分区

mysql查看表分区

文档中心

SELECT
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
FROM information_schema.partitions WHERE
table_schema = SCHEMA()
AND table_name=‘tb_file_upload_message’;