SQL Language | AyyazTech

MySQL: How to get latest updated Tables’ list

Posted on September 2, 2015 by admin

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 ?

Posted on July 7, 2015 by admin

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