当前位置：网站首页>Exclusive lock

Exclusive lock

2022-07-26 06:51:00 【Leon_ Jinhai_ Sun】

Exclusive lock （EXclusive Lock）, also called X lock 、 An exclusive lock 、 Write lock . For row lock .
When a transaction locks the data , Other transactions cannot add any locks to the locked data , Again because InnoDB Yes select Statement is unlocked by default , So other transactions can't be written , It is still allowed to read （ Although read locks are not allowed ）.

It is mainly used for writing transactions , No other transactions are allowed to modify .

Lock mode ：
Automatically ：DML Statement default write lock
Manual ：select * from T where id=1 for update;
Release mode ：
commit、rollback;

原网站

版权声明
本文为[Leon_ Jinhai_ Sun]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207181834113396.html