locktables.sql

SET autocommit=0;

LOCK TABLES sakila.actor WRITE;
INSERT INTO sakila.actor (first_name, last_name) 
	VALUES ("BRUCE", "JOHNSON");
UPDATE sakila.actor 
	SET last_name = "JOHNSON" 
	WHERE actor_id = 1;
COMMIT;
UNLOCK TABLES;

SET autocommit=1;
SELECT * 
	FROM sakila.actor 
	ORDER BY last_update DESC 
	LIMIT 5;