| |
|
|
| | вот собственно код триггера
CREATE TRIGGER files_up BEFORE INSERT ON FilesStore
FOR EACH ROW BEGIN
DECLARE old_id INT DEFAULT 0;
SELECT ZID INTO old_id FROM FilesStore WHERE ZNAME = NEW.ZNAME;
UPDATE FilesLinks SET ZFILEID = NEW.ZID WHERE ZFILEID = old_id;
DELETE FROM FilesStore WHERE ZID = old_id;
END;
|
когда пытаюсь его создать появляется ошибка
#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 3
в чем дело то? | |
| |
|
