13问答网 > mysql 多列唯一索引在事务中select for update是不是行锁

mysql 多列唯一索引在事务中select for update是不是行锁

2025-03-28 18:53:08

推荐回答（1个）

回答1：

代码如下:
vipMember = SELECT * FROM vip_member WHERE
uid=1001 LIMIT 1 # 查uid为1001的会员if vipMember.end_at < NOW():
UPDATE
vip_member SET start_at=NOW(), end_at=DATE_ADD(NOW(), INTERVAL 1 MONTH),
active_status=1, updated_at=NOW() WHERE uid=1001
else:
UPDATE
vip_member SET end_at=DATE_ADD(end_at, INTERVAL 1 MONTH), active_status=1,
updated_at=NOW() WHERE uid=1001