update Archives - 7-Views
MySQL – UPDATE query with LIMIT
Many a times there are certain conditions where ou want to update your records with certain limit attached to it. To update multiple rows using limit in MySQL can be implement by a query: UPDATE table_name SET field=’1′ WHERE id IN (SELECT id FROM (SELECT id FROM table_name LIMIT 0, 10) tmp);
Insert into a MySQL table or update if exists
I we want to add a row to a database table, but if a row exists with the same unique key we want to update the row. For example Let’s say the unique key is employee_id, and in my database there is a row with employee_id=1 , In that case we want to update that […]