- 论坛徽章:
- 0
|
原先的存储过程是这样的
CREATE DEFINER=`root`@`localhost` PROCEDURE `p_AdjustSPKCB`()
begin
/*整理仓库*/
update spkcb set ck_id= ifnull((select cangku.id from cangku where cangku.ckdm=spkcb.ckdm),-1);
/*整理商品*/
update spkcb set goods_id= ifnull((select goods.goods_id from goods where goods.goods_sn=spkcb.goods_sn),-1);
/*整理颜色*/
update spkcb set color_id = ifnull((select goods_color.color_id from goods_color,color where goods_color.color_id=color.color_id and goods_color.goods_id=spkcb.goods_id and color.color_code=spkcb.color_code),-1);
/*整理尺码*/
update spkcb set size_id = ifnull((select goods_size.size_id from goods_size,size where goods_size.size_id=size.size_id and goods_size.goods_id=spkcb.goods_id and size.size_code=spkcb.size_code),-1);
/*删除无效数据*/
delete from spkcb where ck_id=-1 or goods_id=-1 or color_id=-1 or size_id=-1;
Select 1 as MID;
end
执行时报错;
[SQL] CREATE DEFINER=`root`@`localhost` PROCEDURE `p_AdjustSPKCB`()
begin
/*整理仓库*/
update spkcb set ck_id= ifnull((select cangku.id from cangku where cangku.ckdm=spkcb.ckdm),-1);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
修改后如下:
CREATE PROCEDURE `p_AdjustSPKCB`()
begin
/*整理仓库*/
update spkcb set ck_id= ifnull((select cangku.id from cangku where cangku.ckdm=spkcb.ckdm),-1);
/*整理商品*/
update spkcb set goods_id= ifnull((select goods.goods_id from goods where goods.goods_sn=spkcb.goods_sn),-1);
/*整理颜色*/
update spkcb set color_id = ifnull((select goods_color.color_id from goods_color,color where goods_color.color_id=color.color_id and goods_color.goods_id=spkcb.goods_id and color.color_code=spkcb.color_code),-1);
/*整理尺码*/
update spkcb set size_id = ifnull((select goods_size.size_id from goods_size,size where goods_size.size_id=size.size_id and goods_size.goods_id=spkcb.goods_id and size.size_code=spkcb.size_code),-1);
/*删除无效数据*/
delete from spkcb where ck_id=-1 or goods_id=-1 or color_id=-1 or size_id=-1;
Select 1 as MID;
end
可以正常执行了,,,,,,,
各位大大帮忙看下是个什么情况 |
|