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 🙂
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.
It was pressed, thank you :), Maros
Great! Thank you very much for letting us know! Good luck and please feel free to post another question should you encounter other difficulties. Thank you.
The 365 Team