mysql - 创建事件时出错

Question

错误

您好，我在创建事件时遇到以下错误

SQL查询:

CREATE EVENT IF NOT EXISTS BackupTest ON SCHEDULE EVERY1WEEK DO BEGIN CALL TEST(
'test'
);

END

MySQL 说:文档

#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 'EVENT IF NOT EXISTS BackupTest ON SCHEDULE EVERY 1 WEEK DO BEGI' at line 1

请帮忙。

Answer 1

您使用的是复合语句语法，因此需要在 CREATE 语句之前更改分隔符，否则 MySQL 将在第一个分号处停止。试试这个:

DELIMITER $$ 
CREATE EVENT IF NOT EXISTS BackupTest ON SCHEDULE EVERY 1 WEEK DO BEGIN CALL TEST(
'test'
);

END $$
DELIMITER ;