the rollback statement isn't working for me... below is the query I am trying to execute and revert back to original database select * from departments order by dept_no desc limit 10; update departments set dept_name = "data Analysis" where dept_no = 'd010'; commit; rollback;

Hi Ayaz! Thanks for reaching out! We suppose the issue comes from the condition in which you are using the Autocommit button while running these commands. We think currently it is on, which means that you have asked Workbench to automatically commit every statement you are running. Therefore, we advise you to turn the Autocommit mode off and retry. Hope this helps. Best,

Follow this topic

Ayaz Mohammed Abdul Razzak

Last answered:

07 Dec 2021

Posted on:

14 Nov 2021

rollback poblem... unable to revert back to original data values

in SQL / The UPDATE Statement - Part II

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

07 Dec 2021

rollback poblem... unable to revert back to original data values

Submit an answer

related questions