Last answered:

17 Nov 2023

Posted on:

24 Oct 2023

0

Not Working !!

even though i have executed the code as shown in video, I am facing problems ith 'ROLLBACK' not working.


2 answers ( 0 marked as helpful)
Instructor
Posted on:

25 Oct 2023

3

Hi Raghav!
Thanks for reaching out.

There are very few reasons that could lead to this problem. We believe there is a setting that, for some reason, has been switched on or off, and that’s what causes the issue here.

In the SQL editor of MySQL Workbench, there is the possibility to toggle the autocommit mode by pressing a single button. This is the tenth icon below the query tabs. If you’ve pressed this button, it means that this mode will be turned on, and each statement will be committed immediately. Please check if it has been left intact.


Hope this helps.
Best,
Tsvetelin

Posted on:

17 Nov 2023

1

Raghav, I encountered the same thing you did. After I used the "SET autocommit = 0;" statement, it then worked for me. (This might correspond to what Tsvetelin described.)

Submit an answer