mysql: how to get tables' count?

用MySQL这么久,从来不曾想过查询这个东西,呵呵。。。表多了数不过来了:)

mysql> SELECT COUNT(*)  tbls, table_schema dbs FROM information_schema.TABLES GROUP BY table_schema;
+------+--------------------+
| tbls | dbs                |
+------+--------------------+
|    1 | cdcol              |
|   28 | information_schema |
|  112 | ipboard            |
|   29 | miandan            |
|   23 | mysql              |
|    8 | phpmyadmin         |
|    6 | pzblog             |
|    2 | test               |
|   10 | usions             |
+------+--------------------+
9 rows in set (0.02 sec)
mysql> SELECT COUNT(*)  tbls, table_schema dbs FROM information_schema.TABLES WHERE table_schema = 'miandan';
+------+---------+
| tbls | dbs     |
+------+---------+
|   29 | miandan |
+------+---------+
1 row in set (0.00 sec)