Resolved: MySQL Trigger - ROLLBACK not working
Hello everyone!
I would like to ask about the syntax regarding the Triggers course:
After executing ROLLBACK, my database was not reverted to the state corresponding to the last COMMIT line.
I have also unchecked Safe Updates in Workbench Preferences menu.
I am able to DELETE added rows manually, but I am curious, why MySQL does not behave as I would expect using COMMIT & ROLLBACK mechanics.
Thanks in advance :)
Best regards
Maros J
1 answers ( 0 marked as helpful)
Hi Maros J!
Thanks for reaching out.
Can you please check if the Autocommit button has been pressed while you have been working with these queries?
This will mean the autocommit mode will have been disabled.
Once you do that, you can retry running your queries.
Hope this helps.
Best,
Martin
This will mean the autocommit mode will have been disabled.
Once you do that, you can retry running your queries.
Hope this helps.Best,
Martin