ROLLBACK
noun
say it: “ROHL-bak” /ˈroʊlbæk/
The SQL statement that cancels a transaction and undoes its changes.
What does ROLLBACK do in a relational database?
ROLLBACK — A statement that reverses a transaction's uncommitted changes.
START TRANSACTION;
DELETE FROM purchase_order
WHERE order_id = 10;
ROLLBACK;
In a sentence
- “The second update failed, so ROLLBACK undid the first one too.”
Level: Journeyman · More SQL terms at this level
Updated