The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

MySQL Trigger – ROLLBACK not working

MySQL Trigger – ROLLBACK not working

Super Learner

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 Answer

365 Team

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

4 months

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

4 months
Online Data Science Training
SAVE 60%