SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
mysql统计某一个数据库中有几张表
原文:http://www.cnblogs.com/bluewhy/p/5001249.html