mysql 调用带返回值的存储过程 sql语法不要拿来了

Question

存储过程：
create procedure proc_t(out uname varchar(50),out upwd varchar(50),in uid int)
BEGIN
select name,pwd into uname,upwd from bbs where id=uid;
end
----------
如何在mysql里调用这个存储过程获得uname,upwd的值

Answer 1

call proc_t(@uname,@upwd,5);
select @uname,@upwd ;
帮你顶，呵呵。本回答被提问者和网友采纳