======procedure======
create procedure pro(in id int,out name varchar(20),out sals int)
begin
select sname,sal into name,sals from stu
where sno= id;
end
======function======
create function fun(id int) returns varchar(20)
begin
declare name varchar(20) default 'aaaa';
select sname into name from stu
where sno= id;
return name;
end