Código:
me diceDELIMITER | CREATE TRIGGER linalbar_trigger AFTER INSERT ON linalbar FOR EACH ROW BEGIN DECLARE data_alb DATE; SELECT dataalb into data_alb from albara where serie = new.serie and albara = new.albara; UPDATE articles SET stockact = stockact - new.quantitat, darreravenda = data_alb WHERE codi = new.article; END; | DELIMITER ;
Código:
a que se debe el error, creo que las versiones son correctas #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 'DELIMITER | CREATE TRIGGER linalbar_trigger AFTER INSERT ON linalbar FOR EA' at line 1
gracias