create procedure proc_a(out getName varchar(50),out getPwd varchar(50),int setId) begin select name into getName,pwd into setid from user where id=setId; end