56,677
社区成员
发帖
与我相关
我的任务
分享
set @a=1;
select @a:=count(0) from table1;
if @a>0
...
else
...
end if;
CREATE
PROCEDURE ps_ddgl_ggwxx_insert(IN ps_sblxid INT(11), IN ps_sblxmc VARCHAR(20) CHARACTER SET UTF8, IN ps_ggwzbh VARCHAR(20) CHARACTER SET UTF8, IN ps_ggwzmc VARCHAR(20) CHARACTER SET UTF8, IN ps_bzxx VARCHAR(20) CHARACTER SET UTF8, OUT exceResult INT)
COMMENT '新增广告位'
BEGIN
START TRANSACTION;
select count(*) into @likeset from ddgl_ggwxx where ggwzbh = ps_ggwzbh ;
select count(*) into @totals from ddgl_ggwxx where sblxid = ps_sblxid ;
select ggwsx into @ggwsx from ddgl_sblx where lx_id = ps_sblxid ;
IF(@totals >= @ggwsx) then
SET exceResult = 3;
ELSEIF(@likeset >0) then
SET exceResult = 2;
else
INSERT INTO ddgl_ggwxx ( sblxid, sblxmc, ggwzbh, ggwzmc, bzxx) VALUES(ps_sblxid, ps_sblxmc, ps_ggwzbh, ps_ggwzmc, ps_bzxx);
COMMIT;
SET exceResult = 1;
end if ;
END