Following query will show a list of the all latest tables which are changed/updated ( by inserting/deleting/updating rows ) recently.
USE information_schema; SELECT TABLE_SCHEMA , TABLE_NAME FROM TABLES WHERE UPDATE_TIME IS NOT NULL AND UPDATE_TIME > NOW() - INTERVAL 1 DAY AND TABLE_SCHEMA = 'Your_Database_Name'