CREATE TRIGGER modTRIGGER AFTER UPDATE OF
field1,field2,field3
ON myTABLE
BEGIN
UPDATE myTABLE
SET modDATE=datetime()
WHERE key=old.key
Does this fire when any one (Field1, Field2 or Field3) changes? or do they ALL have to be changed?
If I do an UPDATE and set the values to what they already are does this fire?