Update trigger problem.

[Ken Ekholm]

I have problem to create a trigger in MySQL.
What I want to do, is only when table settings's column delay is changed
it would trigger a insert to table delaylog.

I have tried with this code but it doesn't work.


CREATE TRIGGER delaylog
AFTER UPDATE ON settings FOR EACH ROW
BEGIN
IF UPDATE(delay) THEN
insert into delaylog(delayvalue) select delay from settings where id=1;
END IF;
END;

Can someone help me?