ROLLBACK

Undo on error with ROLLBACK.

ROLLBACK undoes a transaction. All changes before COMMIT are discarded.

BEGIN;
DELETE FROM orders WHERE id = 1;
ROLLBACK;

The delete is undone.

ROLLBACK — details

ROLLBACK preserves data on error. It undoes mistaken deletes or updates.

For example, if you accidentally ran a DELETE without WHERE and the transaction is still open, ROLLBACK brings back every deleted row.

Write a DELETE and undo it with ROLLBACK.

Show example solution

BEGIN;
DELETE FROM orders WHERE id = 1;
ROLLBACK;

Add ROLLBACK

BEGIN;
DELETE FROM orders WHERE id = 1;
____;

Show answer

BEGIN;
DELETE FROM orders WHERE id = 1;
ROLLBACK;

Next lesson: SAVEPOINT