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

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

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.