Re: Help for newbie to triggers

[Greg Johll]

Correct you are, and many thanks.

The final trigger looks like this:

CREATE TRIGGER updateGroups AFTER UPDATE ON tblPerson
FOR EACH ROW
BEGIN
IF NEW.deletedFlag = 1 THEN
DELETE FROM tblpersongroup WHERE personID=NEW.personID;
ELSEIF NEW.deletedFlag = 0 THEN
INSERT INTO tblpersongroup(personID,groupID) VALUES(NEW.personID,2);
END IF;
END;

(There was a typo in the original, tblPerson.deletedFlag == 2, should have been == 0)

Greg