sunnyandpenta's recent timeline updates sunnyandpenta's recent timeline updates |
sunnyandpentaV2EX member #484618, joined on 2020-04-18 13:37:24 +08:00 |
sunnyandpenta's recent replies
Apr 10, 2022 Replied to a topic by dearzhw › 职场话题 › 得物干一年有必要跳吗 |
米哈游只给 30 吗？只涨 2k 的话+双休，感觉不是很值得，跳槽都是有风险的，我感觉给的不够
Apr 3, 2022 Replied to a topic by Features › MySQL › 关于 mysql 并发的问题又来了 |
start transaction
1.SELECT balance FROM user where user_id = #{userId} for update;
2. int affectRows = update user set balance=balance-100 where user_id = #{userId} and balance>=100;
3.
if(affectRows > 0){
commit;
}else{
rollback;
}
1.SELECT balance FROM user where user_id = #{userId} for update;
2. int affectRows = update user set balance=balance-100 where user_id = #{userId} and balance>=100;
3.
if(affectRows > 0){
commit;
}else{
rollback;
}
Select Language