SELECT COUNT(*) TABLES,
table_schema FROM information_schema.TABLES
WHERE table_schema = ‘数据库表名’ GROUP BY table_schema;
查看mysql数据库的所有表
最新推荐文章于 2024-07-05 17:12:03 发布
SELECT COUNT(*) TABLES,
table_schema FROM information_schema.TABLES
WHERE table_schema = ‘数据库表名’ GROUP BY table_schema;