查询MySQL中某个数据库中有多少张表

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES   WHERE table_schema = '数据库' GROUP BY table_schema;

from:http://hi.baidu.com/dongyongzheng/blog/item/dd97680efaa103e1ab6457c5.html