Ошибка синтаксиса SQL?

Question

[ValkyrieMadness]

Что не так?

CREATE TRIGGER exh_locs_check
BEFORE INSERT on exhibits
FOR EACH ROW
BEGIN
SET @exhibit_placements:= 0;
SELECT COUNT(*) into @exhibit_placements FROM exhibits
	JOIN collections_locations
	ON exhibits.id_коллекции = collections_locations.id_коллекции
	WHERE exhibits.id = new.id
    GROUP BY exhibits.id;
IF (@exhibit_placements) = 0 THEN
	SIGNAL SQLSTATE '12345' SET MESSAGE_TEXT='Error';
	END IF;
END

Answer 1

[Rsa97]

Перед запросом измените символ конца команды, иначе первая же встреченная точка с запятой завершает оператор CREATE TRIGGER.

DELIMITER $$

CREATE TRIGGER ...
...
END$$

DELIMITER ;

Comments

[ValkyrieMadness]

DELIMITER $$
CREATE TRIGGER exh_locs_check
BEFORE INSERT on exhibits
FOR EACH ROW
BEGIN
DECLARE @exhibit_placements int;
SET @exhibit_placements = (SELECT COUNT(*)  FROM exhibits
  JOIN collections_locations
  ON exhibits.id_коллекции = collections_locations.id_коллекции
  WHERE exhibits.id = new.id
    GROUP BY exhibits.id);
IF (@exhibit_placements) = 0 THEN
  SIGNAL SQLSTATE '12345' SET MESSAGE_TEXT='Error';
  END IF;
END$$
DELIMITER ;

[Rsa97]

ValkyrieMadness, ЕМНИП, локальные переменные процедуры, объявляемые через DECLARE используются без @.

Answer 2

[ValkyrieMadness]

Так тоже не работает. Ошибка такая же

CREATE TRIGGER exh_locs_check
BEFORE INSERT on exhibits
FOR EACH ROW
BEGIN
DECLARE @exhibit_placements int;
SET @exhibit_placements = (SELECT COUNT(*)  FROM exhibits
	JOIN collections_locations
	ON exhibits.id_коллекции = collections_locations.id_коллекции
	WHERE exhibits.id = new.id
    GROUP BY exhibits.id);
IF (@exhibit_placements) = 0 THEN
	SIGNAL SQLSTATE '12345' SET MESSAGE_TEXT='Error';
	END IF;
END