Last answered:

30 Apr 2024

Posted on:

24 Oct 2023

2

Not Working !!

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


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

25 Oct 2023

5

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

4

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.)

Posted on:

29 Nov 2023

2

Hi Raghav,


I encountered the same problem, and then I found this solution!


https://www.youtube.com/watch?v=mFlWTwhGsZU


I hope this helps you.

Regards,

Romeo

Posted on:

07 Dec 2023

0

There is out there, among MySQL options and at the moment important, an autocommit.


Let´s check the status:

SELECT @@autocommit;
SHOW VARIABLES;


Can we change it?

set autocommit = 0;

set autocommit = 1;


Or using the Workbenck GUI, as Raymond Blažić clearly shows us in a Resolved comment below.

Posted on:

30 Apr 2024

0

I rollback but still get the same thing, I modified the setting as suggested by my fellow @Romeo Thomas, does that mean am I going to recreate the database since rolling back isn't bringing me to the commit I wanted?


Thanks 

Submit an answer