SAVEPOINTS

Here is some example code: — Start a transaction START TRANSACTION; — Execute some statements INSERT INTO customers (id, name, email) VALUES (1, ‘John Doe’, ‘john@example.com’); SAVEPOINT before_update; UPDATE customers SET email = ‘new_email@example.com’ WHERE id = 1; — Check the intermediate result SELECT * FROM customers WHERE id = 1; — If needed, roll […]

SAVEPOINTS Read More ยป