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

In other subjects