统计MySQL中某个数据库中有多少张表

1. mysql> SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
   2. where table_schema = 'db_production' GROUP BY table_schema;
   3. +--------+-------------------+
   4. | TABLES | table_schema |
   5. +--------+-------------------+
   6. | 169 | db_production |
   7. +--------+-------------------+