Lloyd Banks
Lloyd Banks

Reputation: 36659

MySQL DML Triggers

I know MySQL triggers are DML only (update, delete, insert) triggers. In SQL Server, triggers can be done "After" or "Instead of" in relation to the statement it is performed on. SQL Server doesn't support "Before" triggers. What kind of triggers are MySQL DML triggers considered as: "After", "Instead of", or "Before"?

Upvotes: 1

Views: 1081

Answers (1)

bhamby
bhamby

Reputation: 15469

From the CREATE TRIGGER docs:

trigger_time is the trigger action time. It can be BEFORE or AFTER to indicate that the trigger activates before or after each row to be modified.

Upvotes: 1

Related Questions