Mysql Trigger Error

[creations]

Hi everyone,

I've got a table test with 2 fields (Name (Varchar) and ischanged (tynyint(1))). I'm trying to create a trigger on this table, pls can some1 tell me whatz wrong with this syntax:

CREATE TRIGGER trig_test
AFTER INSERT ON test
FOR EACH ROW
BEGIN
SET NEW.isChanged = 1;
END




Creations