I am trying to save only the modified fields in a history/log table with the old and new values.
I was just experimenting with triggers to achieve this, however I want to do it dynamically on the columns
IF Old.colname != New.colname THEN //do something
where colname is a fetched from a cursor looping through all the column names. So far it seems like a MySQl limitaiton or I might be missing something
I have my custom DAO pattern and so I am avoiding to check for all the field changes in the code.Also I have data split across in multiple tables,
Looks like lot of people have dealt with this but not in MySQL as of now.
After this post I did create a stored procedure which emits out a trigger and I tried using a prepared statement to create the trigger on the fly but MySql does not support triggers in prepared statements, is there any fix available or any suggestions on how to handle this otherwise.