MySQL cheatsheet: triggers

triggers.sql

-- Triggered after a INSERT operation on "Students" table
CREATE TRIGGER my_trigger AFTER INSERT ON Students FOR EACH ROW
BEGIN
    -- ... instructions to be performed ... --

END;

-- Triggered before a DELETE operation on "Teachers" table
CREATE TRIGGER my_trigger BEFORE DELETE ON Teachers FOR EACH ROW
BEGIN
    -- ... instructions to be performed ... --

END;