mysql - 如何解决mysql程序中的语法错误？

Question

我正在 mysql 中执行一个过程，过程是-

delimiter $$create procedure getFacility (in id int, out MyFacility VARCHAR(200))begin    select Facility into MyFacility         from facilities         where FacilityID = id ;end $$delimiter ;

它在下面给出错误-

Error Code : 1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end $$delimiter' at line 1(0 ms taken)

如何解决这个错误？

谢谢，
尤加尔

Answer 1

我认为错误是因为 END 和 $$ 之间的空格。尝试 END$$，它应该可以正确编译。

http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html