I wonder how it work!
how rollback worked and we don't put commit before it !!
2 answers ( 0 marked as helpful)
In a previous video, the instructor said ROLLBACK will go back to the previous COMMIT. I think this means it will use the last COMMIT that was entered and if there was never any COMMIT, it will go back to the very beginning when the table was created.
Hi Abd and Zachary!
Thanks for reaching out.
Apart from referring to the video, can you please ensure that the 'autocommit' has been toggled off? This may have impacted the outcome of your executions.
Hope this helps.
Submit an answer
Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly