rollback - How can I undo a mysql statement that I just executed?

Question

How can I undo the most recently executed mysql query?

Answer 1

If you define table type as InnoDB, you can use transactions. You will need set AUTOCOMMIT=0, and after you can issue COMMIT or ROLLBACK at the end of query or session to submit or cancel a transaction.

ROLLBACK -- will undo the changes that you have made