存储过程里面怎么处理并发啊

最新推荐文章于 2021-02-12 10:34:39 发布

乌龙

最新推荐文章于 2021-02-12 10:34:39 发布

阅读量2.7k

点赞数 1

本文链接：https://blog.csdn.net/zhanglongxiang/article/details/48175835

版权

现在我的card表里的count为8 表示有8张卡如果我有10个并发线程去调用最后的结果是card表count为0 但是mycard表会有10条记录
就是10个人抢8张卡结果10个人都抢到了

declare update_count int;
declare tmp_update_count int default 0;
declare t_error integer default 0;
declare temp int;
declare continue handler for SQLEXCEPTION set t_error = 1;
start transaction;
   update card set count = count-1 where count >= 1 and cardId = cardId;
   select row_count() into update_count;
   select sleep(1) into temp;
if update_count > 0 then
   insert into myCard (UserId, ShopID, CardID, OrderID, R_Date, Score) values (userId, shopId, cardId, orderId, applyDate, score);
   select row_count() into tmp_update_count;
end if;

if t_error = 1 then
   set tmp_update_count = 0;
   rollback;
else
    commit;
end if

select tmp_update_count as update_count;