mysql 查看某个库下所有表的数据量

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

 

 

posted @ 2020-05-09 14:35  歪~  阅读(3790)  评论(0)    收藏  举报