Therefore, when we physically DELETE a blog entry, it’s full audit history is also removed.
If multiple triggers of the same kind are defined for the same event, they will be fired in alphabetical order by name.
When the triggers on plain tables (not foreign tables).
It’s not necessary to define a DELETE trigger since a post is marked as deleted by setting it’s deleted field to true.
The first My SQL command we’ll issue is a little unusual: Our trigger body requires a number of SQL commands separated by a semi-colon (;).
has completed); or instead of the operation (in the case of inserts, updates or deletes on a view).