PHP/MYSQL - Rollback or list last rows affected by update
Posted: Thu Apr 05, 2012 2:36 pm
Hi everyone,
I performed a MYSQL update using php, however the update query was incorrect and updated the wrong rows.
Is it possible to rollback the update query or at least SELECT the rows performed by the last update query so I can tell which rows i need to change back?
thanks.
I performed a MYSQL update using php, however the update query was incorrect and updated the wrong rows.
Is it possible to rollback the update query or at least SELECT the rows performed by the last update query so I can tell which rows i need to change back?
thanks.