parser

Написать ответ на текущее сообщение

 

 
   команды управления поиском

Ответ

Mizter Egoist 22.04.2016 15:46

^void:sql{
	CREATE TRIGGER pages_ai FOR pages
		AFTER INSERT
		POSITION 32000
	AS
	BEGIN
		INSERT INTO path (anc, dsc, lvl)
		VALUES (NEW.eID, NEW.eID, 0)
	END
}
И без ; и с ^;
CREATE TRIGGER pages_ai FOR pages AFTER INSERT POSITION 32000 AS BEGIN INSERT INTO path (anc, dsc, lvl) VALUES (NEW.eID, NEW.eID, 0); END; ' 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 'FOR pages AFTER INSERT POSITION 32000 AS BEGIN INSERT INT' at line 1