mysql查询一个库中有多少张表
- 在
information_schema
下打开查询,输入语句:SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'test';
mysql查询一个库中有多少张表
information_schema
下打开查询,输入语句: SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'test';