-- MySQL中列出所有库以及对应的表
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema', 'mysql', 'sys','performance_schema')
-- 统计各个数据库的表数量
SELECT table_schema, count(table_name)
FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema', 'mysql', 'sys','performance_schema')
GROUP BY TABLE_schema;