Rick, That is what I ended up doing, a loop reading the description of the table in shell :)
Regards Gael On Fri, Jun 22, 2012 at 6:54 PM, Rick James <rja...@yahoo-inc.com> wrote: > Suggest using a script to read information_schema and construct the > TRIGGER. After all, the fields are not going to change from one invocation > of the trigger to the next, so don't have the "dynamic" code inside the > trigger. > > > -----Original Message----- > > From: Hal?sz S?ndor [mailto:h...@tbbs.net] > > Sent: Thursday, June 21, 2012 5:05 PM > > To: mysql > > Subject: Re: Triggers and column names > > > > >>>> 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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Gaël Martinez