procedure和function实例

======procedure======

create procedure pro(in id int,out name varchar(20),out sals int)beginselect sname,sal into name,sals from stuwhere sno= id;end

======function======

create function fun(id int) returns varchar(20)begindeclare name varchar(20) default 'aaaa';select sname into name from stuwhere sno= id;return name;end