Syntax problem

[Sébastien]

I have a problem in my trigger but I don't no where :

I'm running on MySQL 5.0.18

Code :
delimiter //
CREATE TRIGGER trg_conso_entree AFTER UPDATE ON conso_entree
FOR EACH ROW
BEGIN
IF ((NEW.entree = '1') AND (OLD.entree = '0')) THEN
UPDATE consommable SET consommable.qtestock = consommable.qtestock + new.qte WHERE consommable.reference = new.refproduit
END IF;
END//
delimiter ;

----------------------------------

Error :
requête SQL:

delimiter // CREATE TRIGGER trg_conso_entree AFTER UPDATE ON conso_entree FOR EACH ROW BEGIN IF ((NEW.entree = '1') AND (OLD.entree = '0')) THEN UPDATE consommable SET consommable.qtestock = consommable.qtestock + new.qte WHERE consommable.reference = new.refproduit END IF;

MySQL a répondu:

#1064 - Syntax error near 'delimiter //
CREATE TRIGGER trg_conso_entree AFTER UPDATE ON co' at line 1

-------------------------------

If you want to test here is the code of the table :
CREATE TABLE `conso_entree` (
`num` int(11) NOT NULL auto_increment,
`datecom` date NOT NULL default '0000-00-00',
`dateentree` date default NULL,
`qte` int(11) NOT NULL default '0',
`entree` enum('1','0') NOT NULL default '0',
`refproduit` varchar(5) NOT NULL default '',
PRIMARY KEY (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;