MySQL Forums
Forum List  »  Triggers

Re: issues with triggers
Posted by: Rick James
Date: May 28, 2014 10:27AM

BEGIN
select NEW.nivel := area.nivel+1 from area where area.area_id = New.area_pai;
END

(or something like that)

The important concept:
Set NEW.column_name = ... -- instead of UPDATE

Options: ReplyQuote


Subject
Views
Written By
Posted
2448
May 26, 2014 11:09AM
984
May 26, 2014 11:16AM
Re: issues with triggers
997
May 28, 2014 10:27AM
1051
May 27, 2014 03:47PM


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.