Trigger If Statement

[Jordan Johnson]

So I'm trying to create an IF statement within my fancy new trigger, but mySQL really isn't very happy about it.


delimiter |
CREATE TRIGGER addCorp BEFORE UPDATE ON characters
FOR EACH ROW
BEGIN
IF NEW.corporationID != NULL THEN
INSERT INTO corporations SET corporationID = NEW.corporationID ON DUPLICATE KEY UPDATE corporationID = corporationID;
END IF;
END;
|
delimiter ;


Anyone have some hints as to how to make this work?

Thanks!



Edited 1 time(s). Last edit at 01/16/2011 01:24AM by Jordan Johnson.