>_BeginnerCoder
Donate

Lesson 23 — Transactions & rollback

All or nothing

BEGIN starts a transaction; ROLLBACK undoes it so partial changes never persist.

Why it matters: it keeps data consistent when something fails midway.

Task

Rollback the second insert and show only the first row.

← Back
Next →

Enjoying this lesson? Share it 👇

Keep going with Databases & SQL

Ready for more? These paid resources pick up where this lesson leaves off.

Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.