>>>> 2012/06/21 17:06 -0500, Gael Martinez >>>> I'm getting that done today thru a large static trigger script and I would like something more dynamic... <<<<<<<< For that it is needful to look up the table in INFORMATION_SCHEMA.COLUMNS, and, yes, you can look up the field names--but then what will you do with the character strings that are the field names? use PREPARE and EXECUTE for the comparisons, being ware of NULL?
In MySQL help it is written that for its own purposes MySQL actually tracks all the information that you crave, but it nowhere is written that a BEFORE-UPDATE trigger can make use of it. Maybe UDF, but I know naught about that. Since BEFORE is called on every attempt, successful or not, maybe AFTER would be better. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql