mysql 查询整个数据库所有表的行数

>use information_schema;
>select sum(table_rows) from tables where TABLE_SCHEMA = "test" order by table_rows asc;

  

posted @ 2019-05-31 17:14  RoyFans  阅读(12129)  评论(0编辑  收藏  举报