mysql> SELECT count(*) TABLES, table_schema FROM information_schema.TABLES
where table_schema = 'db_production' GROUP BY table_schema;
+--------+-------------------+
| TABLES | table_schema |
+--------+-------------------+
| 169 | db_production |
+--------+-------------------+
where table_schema = 你的数据库名