Un trigger récalcitrant

Bonjour à tous,

Je suis en train de créer un trigger pour ma base mysql. J'ai une erreur de syntaxe.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
delimiter //
CREATE TRIGGER fin_activite AFTER UPDATE ON pharmacie
FOR EACH ROW
BEGIN
    IF (NEW.dte_fin_activite != "0000-00-00") THEN
        DECLARE nbAsso SMALLINT;
 
        SELECT COUNT(*) AS nb INTO nbAsso
        FROM exercer
        WHERE exercer.num_am_pharmacie = NEW.num_am_pharmacie;
 
        IF (nbAsso > 0) THEN
            UPDATE exercer SET fin_exercice = NEW.dte_fin_activite
                WHERE exercer.num_am_pharmacie = NEW.num_am_pharmacie;
        END IF;
    END IF;
END//
delemiter ;

MySQL me dit que mon erreur est à la ligne "DECLARE nbAsso SMALLINT;".

Quelqu'un peut m'aider ?

delimiter // CREATE TRIGGER fin_activite AFTER UPDATE ON pharmacie FOR EACH ROW BEGIN IF (NEW.dte_fin_activite != "0000-00-00") THEN SET @nbAsso :=(SELECT COUNT(*) FROM exercer WHERE exercer.num_am_pharmacie = NEW.num_am_pharmacie); IF (@nbAsso > 0) THEN UPDATE exercer SET fin_exercice = NEW.dte_fin_activite WHERE exercer.num_am_pharmacie = NEW.num_am_pharmacie; END IF; END IF; END// delemiter ;