我正在尝试构建一个计划查询,但有东西触发了一个错误,不清楚出了什么问题。活动日程安排对我来说有点新鲜,但我还有很多其他工作要做,所以我缺少一些信息:
DELIMITER //
CREATE EVENT gen_firstJoins
ON SCHEDULE EVERY 1 HOUR
ON COMPLETION PRESERVE
DO BEGIN
CREATE TEMPORARY TABLE tmp_joins SELECT username, MIN(player_join) AS player_join FROM joins GROUP BY username ORDER BY player_join ASC ;
TRUNCATE joins_first;
INSERT INTO joins_first (username, player_join) SELECT username, player_join FROM tmp_joins GROUP BY username ORDER BY player_join;
END//
DELIMITER ;
错误:
错误1064(42000):您的SQL语法有错误;查看与MySQL服务器版本对应的手册,了解在第6行的"ame,MIN(player_join)AS player_joinFROM joins GROUP BY username ORDER BY playe"附近使用的正确语法
在评论中回答,因此将评论转发为答案Re:https://meta.stackexchange.com/questions/90263/unanswered-question-answered-in-comments
你可能有隐藏的字符/换行符等?
只需选择并删除整个作品"username"(在select之后),然后尝试重新键入。