Почему выдает ошибку создание триггера?

Question

[empt1ness]

CREATE TRIGGER fff
BEFORE INSERT ON stats
FOR EACH ROW BEGIN
   SET NEW.column11 = (NEW.column1 + NEW.column2 + NEW.column3 + NEW.column4 + NEW.column5 + NEW.column6 + NEW.column7 + NEW.column8 + NEW.column9 + NEW.column10) / 10;
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 '' at line 4 */

Comments

[Akina]

Потому что код создания состоит из нескольких предложений, а про DELIMITER кто-то забыл...

Answer 1

[Akina]

CREATE TRIGGER fff
BEFORE INSERT ON stats
FOR EACH ROW
   SET NEW.column11 = (NEW.column1 + NEW.column2 + NEW.column3 + NEW.column4 + NEW.column5 + NEW.column6 + NEW.column7 + NEW.column8 + NEW.column9 + NEW.column10) / 10;

или

DELIMITER ;;

CREATE TRIGGER fff
BEFORE INSERT ON stats
FOR EACH ROW 
BEGIN
   SET NEW.column11 = (NEW.column1 + NEW.column2 + NEW.column3 + NEW.column4 + NEW.column5 + NEW.column6 + NEW.column7 + NEW.column8 + NEW.column9 + NEW.column10) / 10;
END;
;;

DELIMITER ;