Question

mysql创建存储过程错误 大家帮帮忙

mysql> create procedure proc_run(out getName varchar(50),out getPwd varchar(50)
,setId int)
-> begin
-> select name into getName,pwd into getPwd from bbs where id=setId;
-> end+
ERROR 1327 (42000): Undeclared variable: pwd
我的数据表里有name,pwd,id这3列

Answer 1

delimiter //
create procedure proc_run(out getName varchar(50),out getPwd varchar(50),setId int)
begin
select name ,pwd from bbs where id=setId into getName, getPwd;
end
//
已测，通过

Answer 2

你这是ORACLE的语法吧？
MYSQL的话，应该是这样

create procedure proc_run (@getname varchar out,@getpwd varchar out,@setid int)
as
begin
select @getname=name,@getpwd=pwd from userinfor where id=@setid;
end
go

Answer 3

楼上的怎么那么象SqlServer的语法呢。MySql的好像是这样的吧：
create procedure proc_run(out getName varchar(50),out getPwd varchar(50) ,setId int)
begin
select name,pwd into getName,getPwd from bbs where id=setId;
end