Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

09 Sept 2022

Posted on:

09 Sept 2022

2

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)
Instructor
Posted on:

09 Sept 2022

0

Hi Alessandro!
Thanks for reaching out.

Thanks for sharing this piece of information with the Community!

Best,
Tsvetelin

Submit an answer