Set a savepoint, set book 1’s price to 0, roll back to the savepoint, then show book 1’s price (it should be unchanged). Column: price.

Answer

SAVEPOINT sp1; UPDATE books SET price = 0 WHERE id = 1; ROLLBACK TO SAVEPOINT sp1; SELECT price FROM books WHERE id = 1;