SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = ‘performance‘ GROUP BY table_schema;
这里 table_schema = ‘数据库名字‘
【MySQL】 查询某个数据库有多少张数据表
原文：http://www.cnblogs.com/sxdcgaq8080/p/6233120.html
