PRIMARY KEY (`id`), UNIQUE KEY `uk_name` (`name`));INSERT INTO `t1` (`name`, `level`) VALUES ('A',0);# 出现问题的...sql语句如下,并发情况下就会出现死锁INSERT ignore INTO `t1` (`name`, `level`) VALUES ('A',0);update t1 set level = 1 where...第二条语句
update t1 set level = 1 where name = "A"; 通过唯一键更新数据库字段。...starting index readmysql tables in use 1, locked 1LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s)MySQL...sec starting index readmysql tables in use 1, locked 13 lock struct(s), heap size 376, 2 row lock(s)MySQL