session1.sql

-- session 1
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 last_name INTO @last_name 
	FROM sakila.actor 
	WHERE actor_id = LAST_INSERT_ID();
UPDATE sakila.actor 
	SET last_name = @last_name 
	WHERE actor_id = 1;
COMMIT;