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’  

MySQL: How to duplicate a row using SQL ?

Use following SQL query to duplicate any single row. Use your own field names to make this working in your case. insert into packages (`field_1`, `field_2`, `field_3`, `field_4`) select `field_1`, `field_2`, `field_3`, `field_4` from packages where id=1