创建 mysql 事件时出现问题。启动事务错误 [重复]

问：

我该如何创建一个事件，删除早于 15 减去的表的行，并将其值加回其他表。在下面的代码中，mysql说我在第5行有一个语法错误

CREATE EVENT add_reserve_to_store_products_and_delete_reservations
ON SCHEDULE EVERY 15 MINUTE
DO
BEGIN
 START TRANSACTION;
 UPDATE zaloga z JOIN ( 
SELECT ID_skladisca, ID_izdelek, SUM(kolicina) AS reserve_sum
FROM reserve WHERE time <= NOW() - INTERVAL 15 MINUTE
GROUP BY ID_skladisca, ID_izdelek
) r ON z.ID_izdelek = r.ID_izdelek AND z.ID_skladisca = r.ID_skladisca
SET z.kolicina = z.kolicina + r.reserve_sum;
DELETE FROM reserve WHERE time <= NOW() - INTERVAL 15 MINUTE;
COMMIT;
END;

我尝试删除启动事务并删除，但后来我在提交时出现错误，但它是一个事务非常重要