Что не так в этом SQL запросе?

Question

[khodos_dmitry]

DECLARE i INT DEFAULT 49
WHILE i > 0 DO
UPDATE `cpl_mfo_loans` SET `requirements` = (SELECT `requirements` FROM `cpl_mfo` WHERE `id` = i) WHERE `mfo_id` = i
SET i = i - 1
END WHILE

Пишет, что ошибка возле DECLARE .

Comments

[ThunderCat]

DECLARE is permitted only inside a BEGIN ... END compound statement and must be at its start, before any other statements.
не вижу у вас BEGIN ... END

Answer 1

[web-mehanik]

https://dev.mysql.com/doc/refman/8.0/en/declare.html
DECLARE is permitted only inside a BEGIN ... END compound statement and must be at its start, before any other statements.