MySQL 统计每张表的记录数

原文：
https://blog.csdn.net/liuhongwei_study/article/details/86309402

select table_name,table_rows from information_schema.tables where TABLE_SCHEMA='数据库名称' order by table_rows desc;