mysql 计划事件语法错误

Question

您好，我想每隔一小时删除一次 sql 表行。

CREATE EVENT IF NOT EXISTS `money`
ON SCHEDULE
    EVERY  1 HOUR

DO
    BEGIN

    DELETE FROM `money` WHERE `payed` = 'processing' AND `payed2` = 'processing';

    END

我收到此错误:

1064 - 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 8

Answer 1

这有帮助吗？

DELIMITER $$
CREATE EVENT IF NOT EXISTS `money`
ON SCHEDULE EVERY  1 HOUR
DO
BEGIN

    DELETE FROM `money` WHERE `payed` = 'processing' AND `payed2` = 'processing';

END$$

DELIMITER ;

我一直在使用不支持事件的旧服务器版本，但我希望定义它们类似于存储例程。