MySQL Forums
Forum List  »  Triggers

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

Hi,

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.

Thanks,
Swarna



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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem creating multiple triggers on the same table
3390
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.