MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Adding two different Event triggers for the same table
Posted by: Peter Brawley
Date: April 17, 2013 12:56AM

> I have to write trigger which will auto populate A using values in B and C

That's very likely a design mistake.

> i need both "before insert" and "before update" triggers

In a correctly designed table, the primary key should almost never need to be changed.

What problem are you trying to solve with this rube goldberg arrangement?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Adding two different Event triggers for the same table
2194
sushaanth srirangapathi
April 17, 2013 12:47AM
Re: Adding two different Event triggers for the same table
1162
Peter Brawley
April 17, 2013 12:56AM
Re: Adding two different Event triggers for the same table
1163
sushaanth srirangapathi
April 17, 2013 01:01AM
Re: Adding two different Event triggers for the same table
951
Peter Brawley
April 25, 2013 09:54PM


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.