delete_before_actor.sql

USE sakila;
DROP TRIGGER IF EXISTS delete_before_actor;
DELIMITER $$
CREATE TRIGGER delete_before_actor
BEFORE DELETE
ON actor FOR EACH ROW
BEGIN
	INSERT INTO actor_log (event, actor_id, first_name, last_name)
		VALUES ('delete', old.actor_id, old.first_name, old.last_name);
END $$
DELIMITER ;