Re: Update trigger problem.

[Phillip Ward]

How about something like this?

DELIMITER //
CREATE TRIGGER delaylogtrigger
   AFTER UPDATE ON settings 
   FOR EACH ROW
BEGIN
   IF ( old.delay <> new.delay ) THEN -- delay field has changed 
      insert 
      into delaylog ( delayvalue ) 
             values ( new.delay ); 
   END IF;
END;//
DELIMITER ;

Regards, Phill W.