MySQL Forums
Forum List  »  Triggers

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

It's that column "a" is a unique name formed from the concatenating entries in columns "B" and "c". It's assumed that Concatenating "B" and "c" will give a unique key. So the user will add only values in "b" and "c" and the trigger will create value for Column "a" using "before insert" trigger and insert it into table. There is also a use case in which column "B" or column "c" will be changed. So i need also have a "before update" trigger which will calculate the column "a" before updating.
guys help me out...need to know it in urgent



Edited 1 time(s). Last edit at 04/17/2013 02:44AM by sushaanth srirangapathi.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Adding two different Event triggers for the same table
1081
April 17, 2013 01:01AM


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.