update student set yn=1 where code = '2'; insert into student (code, …) values ('2', ...); transaction B: update student set yn=1 where code = '3'; insert into student (code, …) values ('3', ...); 此时A、B事务会出现