mysql数据库签到记录表_获取MySQL数据库中所有表的记录计数

桃花长相依

就像@Venkatramanan和其他人一样，我发现INFORMATION_SCHEMA.TABLES不可靠(使用InnoDB，MySQL 5.1.44)，每次我在静默表上运行时都会给出不同的行数。这是一种相对hacky(但灵活/适应性)的生成大型SQL语句的方法，您可以将其粘贴到新查询中，而无需安装Ruby gems和东西。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                         SELECT "ndb_binlog_index" AS table_name, COUNT(*) AS exact_row_count FROM my_schema.ndb_binlog_index UNION 复制并粘贴除了最后一个UNION以获得良好的输出，如，+------------------+-----------------+| table_name       | exact_row_count |+------------------+-----------------+| func             |               0 || general_log      |               0 || help_category    |              37 || help_keyword     |             450 || help_relation    |             990 || help_topic       |             504 || host             |               0 || ndb_binlog_index |               0 |+------------------+-----------------+8 rows in set (0.01 sec)