This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
The commit and rollback statements don't work without a "set autocommit=0;"
in SQL / MySQL Triggers
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)
Thanks for reaching out.
Thanks for sharing this piece of information with the Community!
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?