[mysql] declencheur

create trigger controlDate 
before insert
on calendrier
for each row
begin
DECLARE erreur_date CONDITION FOR 1002;
DECLARE EXIT HANDLER FOR erreur_date SET @error = 'Attention la date debut est superieur à la date fin';
if(new.date_d>new.date_f)then
SIGNAL erreur_date;
end if;
end;//

requête SQL: 

CREATE trigger controlDatebefore INSERT ON calendrier
FOR each
ROW 
BEGIN DECLARE erreur_date CONDITION
FOR 1002 ;



MySQL a répondu: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6