Hi, I believe you have a mistake in ROLLBACK example. If you changed name to 'Johnson" and made COMMIT then you are not able to get back to 'Winnfield' anymore, right?

Hi Małgorzata! Thanks for reaching out. In Minute 1:50 we display Winnfield as a reference to what ROLLBACK; would have displayed otherwise; i.e. if COMMIT; had not been executed. You are right when you say "the last name should not change to 'Winnfield' since the change from 'Winnfield' to 'Johnson' occurred BEFORE the last commit". You could also think of it as: "if there was no commit executed, ROLLBACK; would have led to "Winnfield" - the last non-committed state. Hope this helps. Best, Tsvetelin

Follow this topic

Małgorzata Biskup

Last answered:

24 Aug 2022

Posted on:

20 Aug 2022

Resolved: ROLLBACK example with mistake

in SQL / Transaction control language (TCL)

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

24 Aug 2022

Helpful answer

Resolved: ROLLBACK example with mistake

Submit an answer

related questions