Re: Help for newbie to triggers

[Jay Pipes]

You're close! Use the NEW modifier to access the updated information for the tblPerson row.

Delimiter //

CREATE TRIGGER updateGroups AFTER UPDATE ON tblPerson
FOR EACH ROW BEGIN
if (NEW.deletedFlag == 1) {
DELETE FROM tblPersonGroup
WHERE personID = NEW.personID
}

if (NEW.deletedFlag == 2) {
INSERT INTO tblPersonGroup(personID,groupID)
VALUES(NEW.personID,2)
}
END
//

See here for more information:

http://dev.mysql.com/doc/mysql/en/create-trigger.html

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com