如何统计出mysql数据中的表的总数

SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
 where table_schema = '数据名' GROUP BY table_schema;