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

Friday, January 29, 2010

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 = 你的数据库名

This entry was tagged MySQL

comments powered by Disqus

© 2009-2013 lxneng.com. All rights reserved. Powered by Pyramid

go to Top