SELECT
table_name,
table_rows
FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'xxx' ORDER BY table_rows DESC
什么情况下需要该sql?
比如:做DB数据迁移时,探测哪些表有数据,以决定迁移哪些表。
SELECT
table_name,
table_rows
FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'xxx' ORDER BY table_rows DESC
什么情况下需要该sql?
比如:做DB数据迁移时,探测哪些表有数据,以决定迁移哪些表。