MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Update of a single column triggers update of unrelated one
Posted by: Yannick Gansemans
Date: March 12, 2012 05:05PM

Thank you for the reply. Comparing NEW.value to OLD.value indeed solves the problem. I was wrongly expecting NEW.value to be NULL if the column did not receive a value for update.

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


Subject
Views
Written By
Posted
Update of a single column triggers update of unrelated one
8523
Yannick Gansemans
March 12, 2012 04:26AM
Re: Update of a single column triggers update of unrelated one
2339
irek kordirko
March 12, 2012 03:42PM
Re: Update of a single column triggers update of unrelated one
1488
Yannick Gansemans
March 12, 2012 05:05PM


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.