你的sql语法有错误；

hfwmuf9z 于 2021-06-25 发布在 Mysql

关注(0)|答案(1)|浏览(256)

错误：
检查与您的mariadb服务器版本相对应的手册，以便在第5行的“end”附近使用正确的语法

CREATE DEFINER=`root`@`localhost` EVENT `start_game` ON SCHEDULE EVERY 3 MINUTE STARTS '2018-05-05 05:50:07' ON COMPLETION PRESERVE DISABLE DO BEGIN
set @game_id = (select id FROM tbl_game where game_status=0 ORDER BY id ASC LIMIT 1);

update tbl_game set game_status = 1 where id = @game_id;
END

sql mysql Events

来源：https://stackoverflow.com/questions/50208323/mysql-said-1064-you-have-an-error-in-your-sql-syntax

1条答案

按热度按时间

mitkmikd1#

使用 DELIMITER 批处理之前和结束。

DELIMITER $$
CREATE DEFINER=root@localhost EVENT start_game ON SCHEDULE EVERY 3 MINUTE STARTS '2018-05-05 05:50:07' ON COMPLETION PRESERVE DISABLE DO BEGIN set @game_id = (select id FROM tbl_game where game_status=0 ORDER BY id ASC LIMIT 1);

update tbl_game set game_status = 1 where id = @game_id; 
END $$
DELIMITER ;

赞(0）回复(0）举报 2021-06-25

我来回答

你的sql语法有错误；

1条答案

相关问题

热门标签

最新问答