update_after_actor.sql

USE sakila;
DROP TRIGGER IF EXISTS update_after_actor;
DELIMITER $$
CREATE TRIGGER update_after_actor
AFTER UPDATE
ON actor FOR EACH ROW
BEGIN
	INSERT INTO actor_log (event, actor_id, first_name, last_name)
		VALUES ('update', new.actor_id, new.first_name, new.last_name);
END $$
DELIMITER ;