MySQL 存储过程追加合计_MySQL简略存储过程示例(持续追加)

最新推荐文章于 2023-10-11 16:09:37 发布

ArcCl

最新推荐文章于 2023-10-11 16:09:37 发布

阅读量69

点赞数

文章标签： MySQL 存储过程追加合计

本文链接：https://blog.csdn.net/weixin_32312889/article/details/114333437

版权

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

欢迎大家阅读《MySQL简略存储过程示例(持续追加)》,跪求各位点评，by 搞代码

示例二：

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;