Mysql 常用统计表数据方法

-- 统计MySQL指定数据库中有多少张表
SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
where table_schema = '需要统计的数据库名称' GROUP BY table_schema;
 
-- 统计MySQL指定数据库中表数据量
use information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = '数据库名称' order by table_rows desc;

#数据库中所有表的信息
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = '数据库名'
#数据库中每个表的数据量
SELECT table_name,table_rows，table_comment   FROM information_schema.tables
WHERE TABLE_SCHEMA = '数据库名' ORDER BY table_rows DESC;