Is It Possible to update any trigger in Information schema?
+2
A:
You'd better DROP the trigger and then CREATE the trigger. There is reason why there's no ALTER TRIGGER statement in MySQL.
Frank Heikens
2010-03-30 06:48:48
Thanks Frank.. for reasonable explanation.... God Bless
OM The Eternity
2010-03-30 06:55:09