Hi,
is it possible to determine which field was updated in an AFTER UPDATE TRIGGER?

Or is it possible to save data in @variables in a BEFORE UPDATE TRIGGER and read the @variables in an AFTER UPDATE TRIGGER?

Or can I determine which row will be updated in a BEFORE UPDATE TRIGGER (like by reading the id of the primary key from a system variable)?


Thanks,
David

No need for variables, using the aliases OLD and NEW solves one problem.