MySQL Forums
Forum List  »  Triggers

determine if column has been updated
Posted by: Robert Jacob
Date: August 11, 2016 11:07PM

I'm looking for something similar to the UPDATING() function in MSSQL to determine if a columns has been changed. There are many suggestions to use !=, <=>, IS NULL, IS NOT NULL, but my problem is that i have a nullable column. I need to know if the column is intentionally updated to NULL or if the column hasn't been updated. In both cases the NEW.column is null.

Options: ReplyQuote

Written By
determine if column has been updated
August 11, 2016 11:07PM

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.