mysql 创建带输入参数的函数

代码部分：

CREATE DEFINER=`root`@`%` FUNCTION `useableBox`(`p_CBidHold` VARCHAR(50), `p_skuID` INT, `r_GCCountHold` INT, `r_GCIDHold` INT)RETURNS int(11)LANGUAGE SQLNOT DETERMINISTICCONTAINS SQLSQL SECURITY DEFINERCOMMENT '判断暂存货箱是否可以用来下架用（0：不可以用来下架，1：可以用来下架，直接插入容器表2：可以，更新容器）'BEGINDECLARE 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 globalContainerwhere CBid = p_CBidHold;set r_GCCountHold = v_GCCountHold;set r_GCIDHold = v_GCIDHold;if v_countGC!=0 thenif v_onPlace = '' or v_onPlace is null thenif p_skuID = v_skuIDHold thenset v_useableBox = 2;elseset v_useableBox = 1;end if;elseset v_useableBox = 0;end if;elseset v_useableBox = 1;end if;return v_useableBox;END

在工具中截图效果：