Skip to content

Trigger

Create Trigger

CREATE TRIGGER [IF NOT EXISTS] trigger_name
    { BEFORE | AFTER } { INSERT | UPDATE | DELETE }
    ON tbl_name
    CALL func_name

Drop Trigger

DROP TRIGGER [IF EXISTS] trigger_name ON tbl_name

Show Triggers

SHOW TRIGGER [FROM tbl_name]
SHOW TRIGGER STATUS

Comments