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

mysql rollback
Hari kanna picture Hari kanna · May 27, 2010 · Viewed 142.8k times · Source

How can I undo the most recently executed mysql query?

Answer

Vimard picture Vimard · May 27, 2010

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

Related questions

How can I roll back my last delete command in MySQL?

I accidentally deleted some huge number of rows from a table... How can I roll it back? I executed the query using PuTTY. I'll be grateful if any of you can guide me safely out of this...

Read More
mysql transaction - roll back on any exception

Is it possible to roll back automatically if any error occurs on a list of mysql commands? for example something along the lines of: begin transaction; insert into myTable values1 ... insert into myTable values2 ...; -- will throw an error commit; …

Read More
Automatic Rollback if COMMIT TRANSACTION is not reached

Consider the following: START TRANSACTION; BEGIN; INSERT INTO prp_property1 (module_name,environment_name,NAME,VALUE) VALUES ('','production','','300000'); /** Assume there is syntax error SQL here...**/ Blah blah blah DELETE FROM prp_property1 WHERE environment_name = 'production'; …

Read More