Update field on field change trigger
You forget about DELIMITER:

DELIMITER $$

CREATE TRIGGER set_update_flag BEFORE UPDATE ON `reputation_email_score`
FOR EACH ROW
    BEGIN
        IF NEW.`score` &lt;&gt; OLD.`score` THEN
          SET NEW.`updated` = "yes";
        END IF;
END $$
DELIMITER ;


also ; after last END - not necessary