MySQL Forums
Forum List  »  Triggers

Adding two different Event triggers for the same table
Posted by: sushaanth srirangapathi
Date: April 17, 2013 12:47AM

I creates a "Before Insert" and "before Update" trigger on a table.But only one trigger is firing.To be more specific Only the last added trigger is firing. Example : table has three columns (a,B,c) and A is the primary Key column. I have to write trigger which will auto populate A using values in B and C. So i need both "before insert" and "before update" triggers. Can you guys give me help on this. I'm using MySQL workbench.

Options: ReplyQuote


Subject
Views
Written By
Posted
Adding two different Event triggers for the same table
2063
April 17, 2013 12:47AM


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.