摘要： 制造死锁创造环境create table t1_deadlock (a int);create table t2_deadlock (a int);insert into t1_deadlock values (1);insert into t2_deadlock values (2);--第一步update t1_deadlock set a = 1000 where a = 1;--第二步update t2_deadlock set a = 2000 where a = 2;--第三步update t2_deadlock set a = 2000 where a = 2;这里出现了“锁等待 阅读全文