You have to create two triggers, but you can move the common code into a procedure and have them both call the procedure.
More Related Contents:
- Throw an error preventing a table update in a MySQL trigger
- How to abort INSERT operation in MySql trigger?
- MySql Error: Can’t update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
- MySQL Trigger after update only if row has changed
- mysql after insert trigger which updates another table’s column
- How to program a MySQL trigger to insert row into another table?
- TRIGGERs that cause INSERTs to fail? Possible?
- Use a trigger to stop an insert or update
- MySQL trigger On Insert/Update events
- Can a MySQL trigger simulate a CHECK constraint? [duplicate]
- MySQL error 1436: Thread stack overrun, with simple query
- MySQL trigger to update a field to the value of id
- How can I set a maximum number of rows in MySQL table?
- mysql trigger stored trigger is already used by statement which invoked stored trigger
- My MySQL trigger doesn’t work, simple syntax, not complicated
- MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
- MySQL Trigger: Delete From Table AFTER DELETE
- Is it Possible to Enforce Data Checking in MySQL using Regular expression
- Can I launch a trigger on select statement in mysql?
- Using MySQL triggers to log all table changes to a secondary table
- MySQL: How do I use delimiters in triggers?
- MySQL listen notify equivalent
- MySQL disable all triggers
- Calling an url from a trigger in mysql
- MySQL update table based on another tables value
- On Duplicate Key Update same as insert
- How to export and import a .sql file from command line with options? [duplicate]
- a count for each join – optimisation
- The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
- How to pass a variable to a IN clause?