为什么我在mysql中建立存储过程时老是提示有错
mysql>createdatabasewelefen;QueryOK,1rowaffected(0.86sec)mysql>usewelefen;Databasecha...
mysql> create database welefen;
Query OK,1 row affected(0.86 sec)
mysql> use welefen;
Database changed
mysql> delimiter//
-> create procedure getversion(out param1 varchar(50))
-> begin
-> select version() into param1;
ERROR 1064(42000):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 'delimiter//
create procedure getversion(out param1 varchar(50))
begin
select ver' at line 1 展开
Query OK,1 row affected(0.86 sec)
mysql> use welefen;
Database changed
mysql> delimiter//
-> create procedure getversion(out param1 varchar(50))
-> begin
-> select version() into param1;
ERROR 1064(42000):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 'delimiter//
create procedure getversion(out param1 varchar(50))
begin
select ver' at line 1 展开
1个回答
展开全部
没有select version()
只有select @@version
只有select @@version
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
