1.
##查看所有表信息
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = '数据库名称' \G;
2.
##查看各个表数据量
SELECT table_name,table_rows FROM information_schema.tables WHERE TABLE_SCHEMA = '数据库名称' ORDER BY table_rows DESC;
转自自:https://blog.csdn.net/u013985879/article/details/106576718