1、两个Session各两条SQL产生死锁 准备数据 # 建表 CREATE TABLE teacher ( id INT PRIMARY KEY, name VARCHAR(10) ); # 测试数据 INSERT INTO teacher VALUES (1, 'zhangsan'); INSERT INTO teacher VALUES (2, 'lisi'); INSERT INTO teacher VALUES (3, 'wangwu'