creations
02-07-2005, 10:45 AM
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
:confused:
Creations
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
:confused:
Creations