mysql - 创建过程mysql错误在 ''附近

Question

我的MySQL语句:

CREATE PROCEDURE latest_procedure() BEGIN
DELETE ac.* FROM s_articles_categories AS ac JOIN s_articles AS a ON ac.articleID = a.id WHERE ac.categoryID = 38;
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 2 

对于此错误的原因有什么建议吗？

Answer 1

您缺少分隔符，需要关闭end

delimiter //

CREATE PROCEDURE latest_procedure() BEGIN
DELETE ac.* FROM s_articles_categories AS ac JOIN s_articles AS a ON ac.articleID = a.id WHERE ac.categoryID = 38;
END;//

delimiter ;