mysql简单存储过程示例(持续追加) 示例一： create procedure test(in myid int(3),in myname varchar(22),in myage int(3))if myid=0then insert into a(name,age) values(myname,myage);else update a set a.name=myname,a.age=myage where a.id=myid;end i
mysql简单存储过程示例(持续追加)示例一：
create procedure test(in myid int(3),in myname varchar(22),in myage int(3)) if myid=0 then insert into a(name,age) values(myname,myage); else update a set a.name=myname,a.age=myage where a.id=myid; end if
示例二：
create procedure getshang(in worknum varchar(10),out outname varchar(20)) begin declare ret int; declare p1 varchar(10); declare p2 varchar(10); set ret = (select gt.iparentgroup from grouptbl gt,groupmembertbl gmt where gt.igroupid = gmt.igroupid and gmt.smemberid = worknum); if ret = 0 then set p1=(select gt.sgroupname from grouptbl gt,groupmembertbl gmt where gt.igroupid = gmt.igroupid and gmt.smemberid = worknum); set outname = p1; else set p2 = ( select grouptbl.sgroupname from grouptbl where grouptbl.igroupid = (select gt.iparentgroup from grouptbl gt,groupmembertbl gmt where gt.igroupid = gmt.igroupid and gmt.smemberid = worknum) ); set outname = p2; end if; end
调用：
call getshang('abc1122',@groupname); select @groupname;
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！