一个表,一条记录,也能玩出死锁!!!
一、构造测试数据
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);
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);