Mega Code Archive
Categories
/
MySQL Tutorial
/
Trigger
The CREATE TRIGGER Statement
The CREATE TRIGGER statement is used to define a trigger. The CREATE TRIGGER statement associates it with changes occurring in a table. It has the following syntax: CREATE TRIGGER
ON
FOR EACH ROW With the time and event, you must choose from an enumerated set of options: CREATE TRIGGER [BEFORE | AFTER] [INSERT | UPDATE | DELETE]