mysql 创建带输入参数的函数

代码部分：

CREATE DEFINER=`root`@`%` FUNCTION `useableBox`(`p_CBidHold` VARCHAR(50), `p_skuID` INT, `r_GCCountHold` INT, `r_GCIDHold` INT)
RETURNS int(11)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT '判断暂存货箱是否可以用来下架用（0：不可以用来下架，1：可以用来下架，直接插入容器表2：可以，更新容器）'
BEGIN
DECLARE v_countGC int;
DECLARE v_GCCountHold int;
DECLARE v_GCIDHold int;
DECLARE v_skuIDHold int;
DECLARE v_useableBox int;
DECLARE v_onPlace varchar(50);
select count(GCID),skuID,onPlace,GCCount,GCID into v_countGC,v_skuIDHold,v_onPlace,v_GCCountHold,v_GCIDHold from globalContainer
where CBid = p_CBidHold;
set r_GCCountHold = v_GCCountHold;
set r_GCIDHold = v_GCIDHold;
if v_countGC!=0 then
if v_onPlace = '' or v_onPlace is null then
if p_skuID = v_skuIDHold then
set v_useableBox = 2;
else
set v_useableBox = 1;
end if;
else
set v_useableBox = 0;
end if;
else
set v_useableBox = 1;
end if;
return v_useableBox;
END

在工具中截图效果：