Timestamped data from multiple tables

Grafana
1

Hi, I’m currently counting the rows from all tables in my database and displaying it in a grafana table like this

 SELECT  
   TABLE_NAME AS 'Table Name',
   TABLE_ROWS AS 'Total Rows'
 FROM 
    INFORMATION_SCHEMA.TABLES  
 WHERE 
    (TABLE_SCHEMA = 'databaseName' )
 GROUP BY TABLE_NAME;

Its working very well for a total running count, How can I add to the query so that it can filter based on timestamp?

Ive been pulling my hair out on this one
many thanks

Spriggsy

2

This topic was automatically closed after 365 days. New replies are no longer allowed.