创建Mysql存储过程出错
创建Mysql存储过程出错,请高手指点一下,本人初学Mysql。
错误一:
mysql> create procedure simpleproce1 ()
->begin
->select * from jn;
->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 '->begin
->select * from jn;
->end
->' at line 2
后来网上查资料改成这样也还是提示创建失败。
mysql> delimiter //
mysql>
mysql> CREATE PROCEDURE simpleproc ()
-> begin
-> select * from jn;
-> end;
-> //
1307 - Failed to CREATE PROCEDURE simpleproc