how to undo mysql query?

Question

How can I undo the most recently executed mysql query?

Answer 1

Basically: If you're doing a transaction just do a rollback. Otherwise, you can't "undo" a MySQL query.

Answer 2

You can only do so during a transaction.

BEGIN;
INSERT INTO xxx ...;
DELETE FROM ...;

Then you can either:

COMMIT; -- will confitm your changes

Or

ROLLBACK -- will undo

Answer 3

If you define table type as InnoDB, you can use transactions (see the link below). 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.

http://dev.mysql.com/doc/mysql/en/InnoDB_transaction_model.html

ROLLBACK -- will undo the changes that you have made

Answer 4

You can stop a query which is being processed by this

Find the Id of the query process by => show processlist;

Then => kill id;