SAVEPOINT

A named point inside a transaction to which later work can be rolled back.

What does SAVEPOINT do in a relational database?

SAVEPOINT — A named point inside a transaction to which later work can be rolled back.

START TRANSACTION;
SAVEPOINT before_discount;
UPDATE product
SET price = price * 0.90;
ROLLBACK TO SAVEPOINT before_discount;

Level: Journeyman · More Database terms at this level

Updated