Trigger creation syntax error

Question

I'm trying to create a trigger where I set a colunm to 0 if another column is set to 0 and 1 if it's set higher than 0. This is what I wrote

CREATE TRIGGER livre_disponible BEFORE INSERT ON livres
FOR EACH ROW
BEGIN
    IF NEW.nb_exemplaires=0 THEN
            SET NEW.disponible=0;
    ELSEIF NEW.nb_exemplaires>=1 THEN
            SET NEW.disponible=1;
    END IF
END

The error is said to be on line 5 which is the first "SET".

I this the correct syntax to do it?

Answer 1

I didn't find anything wrong with your statement, you need perhaps DELIMITERs

DELIMITER $$
CREATE
    TRIGGER `livre_disponible` BEFORE INSERT ON `livres` 
    FOR EACH ROW 
   BEGIN
        IF NEW.nb_exemplaires=0 THEN
            SET NEW.disponible=0;
        ELSEIF NEW.nb_exemplaires>=1 THEN
            SET NEW.disponible=1;
        END IF;
    END;
$$

DELIMITER ;

Updated : you missed also a ';' ==> END IF; END;