MySQL Forums
Forum List  »  Triggers

Re: Syntax problem
Posted by: Sébastien
Date: March 16, 2006 02:01AM

There is another error:

ERROR: Ponctuation invalide @ 11
STR: //
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;



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;

MySQL a répondu:

#1064 - Erreur de syntaxe pr賠de 'delimiter //
CREATE TRIGGER trg_conso_entree AFTER UPDATE ON co' ࠬa ligne 1

Options: ReplyQuote


Subject
Views
Written By
Posted
2932
March 15, 2006 03:13AM
1865
March 15, 2006 08:01AM
Re: Syntax problem
2363
March 16, 2006 02:01AM
1931
March 15, 2006 08:22AM
1990
March 17, 2006 01:49AM
1797
March 20, 2006 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.