fbpx
11 C
Lahore

MySQL: How to get latest updated Tables’ list

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' 

 

- Advertisement -spot_img

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article