一个表,一条记录,也能玩出死锁!!!

一、构造测试数据

CREATE TABLE `deadlock_test` ( id bigint NOT NULL , uid bigint not null, deleted int not null, PRIMARY KEY (id), UNIQUE KEY `uk_uid` (uid) ) insert into deadlock_test values(1,10,0);