存储过程出现--1172 - Result consisted of more than one row错误的解决方法
下面是带一个输入参数,和两个输出参数的正确的存储过程delimiter &&create procedure user_test(in userid int,out name varchar(100),out uage int)BEGINset @id=userid;SELECT Username,Age into name,uage FROM user WHERE Id=@id LIMIT 1;#SELECT Age into age FROM user WHERE Id=@i