Shulou(Shulou.com)06/01 Report--

Summary

Exclusive lock mode is the most powerful, it is exclusive, exclusive access, it occupies table lock resources, other sessions can only wait

Row share (share update) lock mode is relatively mild, it can coexist with all lock modes, but exclusive lock mode is not allowed.

Although share row exclusive lock mode is not as powerful as exclusive lock mode, it can rank as the second strict lock mode, and it can only be compatible with row share (share update) lock mode.

Row exclusive and share lock modes rank after share row exclusive. It is compatible with three lock modes, but not with the remaining two lock modes.

Training courseware

(charge 20 yuan)

Contact information

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.