MySQL Forums
Forum List  »  Triggers

Problem creating multiple triggers on the same table
Posted by: swarna bandar
Date: April 09, 2012 07:33PM


I am trying to create multiple triggers but with different events and getting an error. For example, one trigger is for update and another is for insert. When we execute these two triggers in mysql workbench, it shows the following error message:

Error Code: 1235. This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

Please advise.


Edited 1 time(s). Last edit at 04/09/2012 07:38PM by swarna bandar.

Options: ReplyQuote

Written By
Problem creating multiple triggers on the same table
April 09, 2012 07:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.