mysql查询一个库所有表数据量

use information_schema;
select table_name,table_rows from tables WHERE table_schema = 'zgq_zwfw' AND table_rows > 0 order by table_rows desc;