统计MySQL中指定数据库中有多少张表
SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
where table_schema = ‘数据库名称xxx’ GROUP BY table_schema;
统计MySQL中指定数据库中表记录数
use information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = ‘数据库名称xxx’ order by table_rows desc;
where table_schema = 你的数据库名