mysql统计某一个数据库中有几张表

一、当存在information_schema时

SELECT count(*) TABLES, table_schema FROM information_schema.TABLES

where table_schema = 'test' GROUP BY table_schema;