select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = ‘数据库名称‘ order by table_rows desc;
MySQL查询数据库中所有数据表的数据条数
原文:https://www.cnblogs.com/yulongcode/p/11395928.html