MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Each updated column name in trigger
Posted by: Peter Brawley
Date: January 06, 2011 01:35PM

The only mechanism in MySQL for such dynamic SQL is PREPARE with information_schema, but MySQL does not support PREPARE in Triggers, so auto-generation of such Triggers has to be done in an app language.

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Each updated column name in trigger
3302
sunil divyeshvar
December 27, 2010 08:46AM
Re: Each updated column name in trigger
1464
Peter Brawley
December 27, 2010 02:10PM
Re: Each updated column name in trigger
4396
sunil divyeshvar
January 06, 2011 02:08AM
Re: Each updated column name in trigger
1665
Peter Brawley
January 06, 2011 01:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.