Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis of update locks and exclusive locks in mysql. Xiaobian thinks it is quite practical, so share it with you as a reference. I hope you can gain something after reading this article.

I haven't seriously understood the lock of UPDATE operation. Recently, I saw a question on MSDN forum, asking the deadlock problem of heap table update. The question is very simple. There are tables and data similar to this:

CREATE TABLE dbo.tb( c1 int, c2 char(10), c3 varchar(10));GODECLARE @id int;SET @id = 0;WHILE @id

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.