views:

18

answers:

1

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
Thanks Frank.. for reasonable explanation.... God Bless
OM The Eternity