MySQL Forums
Forum List  »  Triggers

fetch updated columns in 'before update' trigger
Posted by: Jon Beyer
Date: September 05, 2019 08:27PM

Is it possible to access the updated columns in a 'before update' trigger? I know that I can check columns one by one, but I want an expression that isn't dependent on updating the trigger as I add more columns.

To provide more color, once a record is in a certain state, only one column should be able to be updated. So I want to reject updates unless this one column is the only column that is to be updated.

Many thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
fetch updated columns in 'before update' trigger
330
September 05, 2019 08:27PM


Sorry, only registered users may post in this forum.

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.