Re: fetch updated columns in 'before update' trigger

[Peter Brawley]

> 'delete and recreate updated trigger'

Can't be done while the Trigger is being invoked.

> I don't want to have to modify my trigger every time I add a column

SQL isn't a complete computer language, Triggers and much else need specific table & column specs. And, in a correctly designed database, DDL changes should be rare except when the requirement changes enough to require a major upgrade, so if you expect to be adding columns often, what problem drives that expectation?

> list of updated columns

You'd need to code that yourself, eg by storing a copy of the Update statement in a table and having the Trigger retrieve and parse it. But it might not be helpful---MySQL doesn't support dynamic SQL in Triggers.