Re: trigger to create a log file

[Roland Bouman]

No. Not in triggers anyway (or in procedures called from a trigger).

But I suggested a solution for that: just let a script generate all these tedious lines of code for you:

select concat(
'if new.'
, column_name
, ' != '
, 'old.'
, column_name
, ' then '
, ...
...
, 'end if'
)
from information_schema.columns
...
..

In most cases you can have the script generate all of you code for you. (Did you check out: http://mysql.gilfster.com/page.php?parent_id=6&page_id=6.0.2 ? Please do, that should tell you how to go about this)