Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

How do I undo a delete in MySQL?

Contents
  1. Can we rollback after delete?
  2. How do I undo in MySQL?
by default the command line client uses auto commit after each command. . @Vijay: Just type "rollback;" + ENTER. . this would indeed work.. but if and only if he explicitly used transactions while executing his delete query, otherwise he cannot 'rollback'. . This should be accepted answer and not the current accepted answer.


Can we rollback after delete?

The operation cannot be rolled back. DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

How do I undo in MySQL?

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

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours