如何查看MySQL分区表信息?

select partition_name part,partition_expression expr,partition_description descr,table_rows  from INFORMATION_SCHEMA.PARTITIONS where TABLE_SCHEMA=SCHEMA() AND TABLE_NAME='_rec_reading_record_v2_book_new'

posted @ 2020-04-08 14:42  荣神益人  阅读(4898)  评论(0编辑  收藏  举报