liklstar 发表于 2014-10-08 16:09

我用navicat premium编写的MySQL实验存储过程，报错？

我用navicat premium编写的MySQL实验存储过程，如下：

create procedure xyz (out title varchar(100))
BEGIN
        select post_title
        into title
        from wp_posts
        where ID = 9;
END

报语法错误：
Error : 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 6
Error : 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 'END' at line 1

请问是什么原因？该如何纠正？

liklstar 发表于 2014-10-08 16:38

奇怪？！我去掉了create procedure...语句和begin ... end语句却能够正确运行？
页: [1]
查看完整版本: 我用navicat premium编写的MySQL实验存储过程，报错？