I need when my tables (not one table many tables) get inserted using mysql information schema

Question

Here is query:

SELECT * FROM information_schema.TABLES T
WHERE T.TABLE_ROWS>0 AND   T.TABLE_NAME  LIKE '%_sales%';

Answer 1

Use the UPDATE_TIME column.

SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_ROWS > 0 AND TABLE_NAME LIKE '%\_sales%'
AND UPDATE_TIME > DATE_SUB(NOW(), INTERVAL 1 DAY)