当前位置：网站首页>MySQL -- the secret of lock -- how to lock data

MySQL -- the secret of lock -- how to lock data

2022-04-23 07:59:00 【Dream river dream】

First look at the structure of the watch
Insert picture description here
Here's the data

The experiment begins

Business 1
blog.csdnimg.cn/ef6ec006b00341d5bdf4e6c0426845a8.png)

Business 2
Insert picture description here

Get lock occupancy information of current database
Insert picture description here

It can be seen that the transaction 1 and 2 Surface operation staffid Index and staffno Indexes , The primary key corresponding to the locked record

版权声明
本文为[Dream river dream]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230629085810.html