savepoint.sql

SELECT * 
	FROM sakila.actor 
	ORDER BY last_update DESC 
	LIMIT 5;

START TRANSACTION;
INSERT INTO sakila.actor (first_name, last_name) 
	VALUES ("BRUCE", "JOHNSON");
SELECT * 
	FROM sakila.actor 
	ORDER BY last_update DESC 
	LIMIT 5;

SAVEPOINT beforeUpdatePenelopeGuiness;
UPDATE sakila.actor 
	SET last_name = "JOHNSON" 
	WHERE actor_id = 1;
SELECT * 
	FROM sakila.actor 
	ORDER BY last_update DESC 
	LIMIT 5;

ROLLBACK TO SAVEPOINT beforeUpdatePenelopeGuiness;
COMMIT;

SELECT * 
	FROM sakila.actor 
	ORDER BY last_update DESC 
	LIMIT 5;