I have code:

CREATE TRIGGER update_after_requirement_on_description
BEFORE UPDATE
ON requirement FOR EACH ROW
BEGIN
    IF !(NEW.description <=> OLD.description) THEN
        UPDATE requirement
        SET NEW.description_previous = OLD.description;
    END IF;
END;

and second one:

CREATE TRIGGER update_after_requirement_on_description
BEFORE UPDATE
ON requirement FOR EACH ROW
IF !(NEW.description <=> OLD.description) THEN
    UPDATE requirement
    SET NEW.description_previous = OLD.description;
END IF;

both return result from db:

#1064 – Something is wrong in your syntax near ” in line 7:
“SET NEW.description_previous = OLD.description;”

what’s wrong ?

thanks