Reputation: 36659
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
Reputation: 15469
From the CREATE TRIGGER
docs:
trigger_time
is the trigger action time. It can beBEFORE
orAFTER
to indicate that the trigger activates before or after each row to be modified.
Upvotes: 1