MySQL Forums
Forum List  »  Triggers

Re: Problem with trigger
Posted by: Bob Field
Date: October 14, 2006 11:06AM

Change it to a BEFORE INSERT trigger and use the SET statement to update the values. This will also require you to do this inline and not via stored procedures.

Options: ReplyQuote


Subject
Views
Written By
Posted
2502
October 14, 2006 07:45AM
Re: Problem with trigger
1607
October 14, 2006 11:06AM
1551
October 15, 2006 10:47AM
1636
October 15, 2006 11:02AM
1678
October 15, 2006 08:36PM
1584
October 15, 2006 09:45PM
1555
October 16, 2006 04:52AM
1653
October 16, 2006 08:32AM


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.