根据非主键id更新流程
image.png- 对当前索引加间隙锁或行锁后,若有其他线程通过主键索引进行更新将出现死锁
https://www.jianshu.com/p/cc6ecabd178c
https://blog.csdn.net/soonfly/article/details/70238902
https://www.jianshu.com/p/cc6ecabd178c
https://blog.csdn.net/soonfly/article/details/70238902
本文标题:MySQL非主键更新
本文链接:https://www.haomeiwen.com/subject/epogehtx.html
网友评论