Mysql 数量增加会锁表吗

淡然

@Ta 2022-11-26 4592点击

UPDATE table SET balance = balance+1 WHERE uid = 1
UPDATE table SET balance = balance+1 WHERE uid = 1
UPDATE table SET balance = balance+1 WHERE uid = 1
UPDATE table SET balance = balance+1 WHERE uid = 1

是不是有行锁

隐藏样式查看源码

回复列表(1|隐藏机器人聊天)

1

老虎会游泳

@Ta / 2022-11-26 / 样 / 源

取决于存储引擎，MyISAM锁表，InnoDB锁行。

添加新回复

回复需要登录。