查看mysql数据库的所有表

SELECT COUNT(*) TABLES, 
table_schema FROM information_schema.TABLES 
WHERE table_schema = ‘数据库表名’ GROUP BY table_schema;