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
2432
sushaanth srirangapathi
April 17, 2013 12:47AM
Re: Adding two different Event triggers for the same table
1341
Peter Brawley
April 17, 2013 12:56AM
Re: Adding two different Event triggers for the same table
1371
sushaanth srirangapathi
April 17, 2013 01:01AM
Re: Adding two different Event triggers for the same table
1104
Peter Brawley
April 25, 2013 09:54PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.