The commit and rollback statements don't work without a "set autocommit=0;"
Good morning. I have run the code written in this lesson, but I forgot that in the previous lessons I had read the comment of someone saying that, if we don't run "SET autocommit=0;" before the COMMIT statement, the ROLLBACK statement won't work. So this lesson has to be updated, too. So by now I have made some changes and I cannot restore the tables as they were when I ran the COMMIT statement, but I hope that this is not a problem anymore since the course is going to finish. Thank you
1 answers ( 0 marked as helpful)
Hi Alessandro!
Thanks for reaching out.
Thanks for sharing this piece of information with the Community!
Best,
Tsvetelin