Syntax error when writing a trigger in MySQL

Question

I'm trying to write a trigger for calculating the average rating of an institution. The idea is this: When an impressin is added to the table, the average score should be calculated using the AVG function. Code:

CREATE TRIGGER 'ratein_up' AFTER INSERT ON 'impressin'
    FOR EACH ROW
    BEGIN
    SET @new_rat:=(SELECT AVG(Rating) FROM impressin);
    UPDATE feed-point SET OLD.AverageRating = @new_rat 
    WHERE id= NEW.idFeedPoint;
    END

Indicates an error in the line:UPDATE feed-point SET OLD.AverageRating = @new_rat WHERE id= NEW.idFeedPoint;

There are so many errors in the code that I'm voting to close as "too broad". You are using single quotes incorrectly around identifiers, you are doing some sort of subtraction after the update, you are attempting to update a row in the source table in an after update trigger. — Gordon Linoff
– Gordon Linoff, Commented Jun 10, 2018 at 21:30
This is not a minus, this is the name of my table.Single quotes formed PHP MyAdmin — Александр Поляков
– Александр Поляков, Commented Jun 10, 2018 at 21:40
Извините за неприятность, я отредактировал триггер и протестировал его, он работает правильно. Необходимо было ввести название таблицы в кавычки. Исправленная строка: UPDATE 'feed-point' SET AverageRating = @new_rat WHERE id = NEW.idFeedPoint; — Александр Поляков
– Александр Поляков, Commented Jun 10, 2018 at 21:51

Александр Поляков · Accepted Answer · 2018-06-10 22:06:20Z

1

I'm sorry for the trouble, I edited the trigger and tested, it works correctly. It was necessary to take the name of the table into quotes. Corrected line

UPDATE `feed-point` SET AverageRating = @new_rat WHERE id= NEW.idFeedPoint;

answered Jun 10, 2018 at 22:06

Александр Поляков

192 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error when writing a trigger in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related