MySQL Forums
Forum List  »  Triggers

Each updated column name in trigger
Posted by: sunil divyeshvar
Date: December 27, 2010 08:46AM

Hi,

I know by applying new.value <> old.value ,

we can know which column got update bt i hv number of columns in my table so it is not possible to write new.value <> old.value for all columns with IF-ELSE statements.

I need to create log table for my master table , so log table contains only field name(i.e. column name) and old and new value.

Is that possible except new.value <> old.value clause ?

Please reply
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Each updated column name in trigger
3306
December 27, 2010 08:46AM


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.