Re: Multiple triggers

[irek kordirko]

Hi,

Mysql doesn't allow to have more that one trigger of the same type on the same table.
It's described here:
http://dev.mysql.com/doc/refman/5.5/en/trigger-syntax.html

Quote

... there are other limitations on the types of triggers you can create. In particular, you cannot have two triggers for a table that have the same activation time and activation event. For example, you cannot define two BEFORE INSERT triggers or two AFTER UPDATE triggers for a table. This should rarely be a significant limitation, because it is possible to define a trigger that executes multiple statements by using the BEGIN ... END compound statement construct after FOR EACH ROW. (An example appears later in this section.)