otóż mam problem z wyzwalaczem.oto jest kod sql:
DELIMITER
CREATE TRIGGER tgr_nazwy
AFTER INSERT OR UPDATE OR DELETE ON documentsPictures
FOR EACH ROW
BEGIN
IF (TG_OP = 'DELETE') THEN
UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = OLD.`documentId` ORDER BY weight LIMIT 1) WHERE `documentId` = OLD.`documentId`;
ELSE
UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = NEW.`documentId` ORDER BY weight LIMIT 1) WHERE `documentId` = NEW.`documentId`;
END IF;
RETURN NEW;
END;
proszę o pomoc,gdzie tu jest błąd