2020-09-27

最新推荐文章于 2020-09-27 20:30:09 发布

转载最新推荐文章于 2020-09-27 20:30:09 发布 · 171 阅读

CC 4.0 BY-SA版权

原文链接：https://www.itranslater.com/qa/details/2110108617692152832 https://stackoverflow.com/questions/286039/get-record-counts-for-all-tables-in-mysql-database

SQL 专栏收录该内容

1 篇文章

订阅专栏

MySQL 借助 INFORMATION_SCHEMA.TABLES 精确统计表记录数

SELECT CONCAT(
    'SELECT "', 
    table_name, 
    '" AS table_name, COUNT(*) AS exact_row_count FROM `', 
    table_schema,
    '`.`',
    table_name, 
    '` UNION '
) 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema = '**my_schema**';

产生如下输出：

SELECT "func" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.func UNION                         
SELECT "general_log" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.general_log UNION           
SELECT "help_category" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.help_category UNION       
SELECT "help_keyword" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.help_keyword UNION         
SELECT "help_relation" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.help_relation UNION       
SELECT "help_topic" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.help_topic UNION             
SELECT "host" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.host UNION