通过 show table 语句得到的所有表名,把表名复制到EXCEL中然后生成select 'table1',count(*) from table1 union all select ''table2,count(*) from table2 union all select 'table3',count(*) from table3 union all ...
如果不是需要精确的数字,则可以直接从INFORMATION_SCHEMA TABLES表中获取TABLE_ROWS 或者从SHOW TABLE STATUS 查看ROW
select ''table2,count(*) from table2 union all
select 'table3',count(*) from table3 union all
...
或者从SHOW TABLE STATUS 查看ROW