Re: Each updated column name in trigger

[sunil divyeshvar]

Sir ,

i need to create one AUDIT table having data of updated column name and its old and new values.

For that i have created trigger by using old.column_name<>new.column_name,

but i have number of columns in my table and if is there any change(add column) in my table i need to recreate the trigger.

i also search it on http://www.artfulsoftware.com/infotree/Transaction time validity in MySQL.pdf

but still i m not getting answer that how to get "UPDATED COLUMN NAME" in my audit table as i dnt want to write all the column names in trigger with if and else values.


Thanks