Discuss Unexpected error in trigger when export in the MySQL Help forum on Dev Shed. Unexpected error in trigger when export MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Time spent in forums: 21 m 39 sec
Reputation Power: 0
Unexpected error in trigger when export
Documentation says that
There cannot be two triggers for a given table that have the same trigger action time and event.
I use mysql 5.5.16. I created two triggers. upd_check1 and sale_tri. I am sure that my two trigger perform two different tables on INSERT event. But why I get this error in both triggers. when I try export database(phpmyadmin doesn't show error but mysql workbench, heidisql, query browser show error).
SQL Error (1235): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'