`

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

 
阅读更多

 SELECT count(*) TABLES, table_schema FROM information_schema.TABLES   

where table_schema = 'fdss_datacenter_new_1' GROUP BY table_schema;  

 

where table_schema = 数据库名

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics