Delimiter //
create procedure buyGoods(in g_id int ,in cl_id int,in num int)
begin
declare price int;
declare s_id int;
select avg(goods_price) from goods where g_id=goods_id into price;
select shop_id from goods where g_id=goods_id into s_id;
set price = price*num;
update shops set income=income+price where shop_id=s_id;
update customers set c_cost=c_cost+price where c_id=cl_id;
insert orders(or_price,or_num,date,shop_id,c_id,good_id) value (price,num,current_date(),s_id,cl_id,g_id);
end;
//
DELIMITER ;
请问大神们为什么里面的update语句不执行呢,也没有报错,最后只执行了insert搞了好久不知道什么原因