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

2023-05-03 本文已影响0人 bigdata张凯翔

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