Re: Triggers and column names

2012-06-22 Thread Gael Martinez
om 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 > > Su

RE: Triggers and column names

2012-06-22 Thread Rick James
l?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 > woul

Re: Triggers and column names

2012-06-21 Thread Hal�sz S�ndor
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 wil