Is it possible to reference NEW and OLD without explicit column names?

[Dag Sondre Hansen]

I am trying to write a generic (table independent) trigger for logging data changes on the column level - with very limited success. (Community server v5.5.34).

My research so far tells there is no way to access the NEW and OLD aliases without explicitly stating column names, since prepared statements are not allowed in triggers and referencing NEW/OLD as NEW.* or OLD.* results in an unknown table error.

Does anyone else know of any way to do this, or am I banging my head against an all too familiar wall?



Edited 1 time(s). Last edit at 06/15/2012 05:58AM by Dag Sondre Hansen.