Menu
I did a big mistake that I updated a table without 'where' clause in MySQL :'(
It is auto-committed.
Is there any way to rollback from it?
470
After you commit the transaction, the changes are visible to other users' statements that execute after the commit. You can roll back (undo) any changes made during the transaction with the ROLLBACK statement (see ROLLBACK.
To roll back the current transaction and cancel its changes, you use the ROLLBACK statement. To disable or enable the auto-commit mode for the current transaction, you use the SET autocommit statement.
Once SQL Server commits a transaction, you cannot run the ROLLBACK statement.
On ending the transaction without specifying committing or rolling back, it will roll back. So, the advice given below is definitely correct: always explicitly commit or rollback.
No, there's no query that will "undo" a committed data-modifying query.
If you have a backup of the database, you can restore the backup and use DBA tools (in MySQL's case, it's mysqlbinlog) to "replay" all data-modifying queries from the logs since the backup back to the database, but skip over the problem query.
If you don't have a backup and all logs since the that backup, there's nothing you can do to recover the data.
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
