mysql - 从 MySql 中的架构获取表行数

Question

我得到了如何通过下面的查询获取总行表的解决方案

SELECT table_name "Table Name", SUM(TABLE_ROWS) "Total Rows"
     FROM INFORMATION_SCHEMA.TABLES 
     WHERE TABLE_SCHEMA = {schema_name} AND table_name IN ('table_1', 'table_2', 'table_3')
GROUP BY table_name;

它将显示截至当天的所有行。

但我想要直到最后一天的行数。我没有得到任何解决方案。

通过上面的查询可以吗？请建议如何获得结果。

Answer 1

请尝试一下

SELECT table_name as "Table Name", count(*) as "Total Rows"
     FROM INFORMATION_SCHEMA.TABLES 
     WHERE TABLE_SCHEMA = {schema_name} AND table_name IN ('table_1', 'table_2', 'table_3')
GROUP BY table_name;