1.查询语句如下:
SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'test' GROUP BY table_schema;
【注:test是库名】
2.运行结果如下:
【注:3是表数量,test是库名;】
SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'test' GROUP BY table_schema;
【注:test是库名】
【注:3是表数量,test是库名;】