查询数据库中表数量:
SELECT
COUNT(*) TABLES,
table_schema
FROM
information_schema.TABLES
WHERE table_schema = ‘teacher’
GROUP BY table_schema ;
SQL
最新推荐文章于 2024-05-14 09:30:00 发布
查询数据库中表数量:
SELECT
COUNT(*) TABLES,
table_schema
FROM
information_schema.TABLES
WHERE table_schema = ‘teacher’
GROUP BY table_schema ;