CREATEPROCEDURE myp2(IN beautyName VARCHAR(20))BEGINSELECT bo.*FROM boys bo
JOIN beauty b
ON bo.id = b.boyfriend_id
WHERE b.name=beautyName;END $
#调用CALL myp2('柳岩')$ #字符集报错#重新设置gbk#set names gbk$
CREATEPROCEDURE myp4(IN beautyName VARCHAR(20),OUT boyName VARCHAR(20))BEGINSELECT bo.boyname INTO boyname
FROM boys bo
JOIN beauty b
ON b.boyfriend_id = bo.id
WHERE b.name=beautyName ;END $
#调用CALL myp4('小昭',@bName)$
SELECT@bName$
案例2:根据输入的女神名,返回对应的男神名和魅力值
CREATEPROCEDURE myp5(IN beautyName VARCHAR(20),OUT boyName VARCHAR(20),OUT usercp INT)BEGINSELECT boys.boyname ,boys.usercp INTO boyname,usercp
FROM boys
JOIN beauty b
ON b.boyfriend_id = boys.id
WHERE b.name=beautyName ;END $
#调用CALL myp5('小昭',@name,@cp)$
SELECT@name,@cp$
4.创建带inout模式参数的存储过程
案例1:传入a和b两个值,最终a和b都翻倍并返回
CREATEPROCEDURE myp6(INOUT a INT,INOUT b INT)BEGINSET a=a*2;SET b=b*2;END $
#调用SET@m=10$
SET@n=20$
CALL myp6(@m,@n)$
SELECT@m,@n$