fbpx
31 C
Lahore
- Advertisement -spot_img

TAG

Database

Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used...

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 ,...

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`,...

Latest news

- Advertisement -spot_img