Last answered:

07 Dec 2021

Posted on:

14 Nov 2021


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

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';



1 answers ( 0 marked as helpful)
Posted on:

07 Dec 2021


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.

Submit an answer