mysql -uroot -p
use information_schema;
select * from tables;
select table_name,table_rows from tables where TABLE_SCHEMA = '要查询数据库名' order by table_rows desc;
mysql -uroot -p
use information_schema;
select * from tables;
select table_name,table_rows from tables where TABLE_SCHEMA = '要查询数据库名' order by table_rows desc;