insert_after_actor.sql

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