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';
commit;
rollback;
1 answers ( 0 marked as helpful)
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,