事务T1:
START TRANSACTION;
INSERT INTO test VALUES(1,'test1','test123');
COMMIT;
事务T2:
START TRANSACTION;
DELETE test WHERE NAME='test1';
COMMIT;
场景1:
开启事务T1,不提交的同时开启事务T2,事务T1执行INSERT完成后,执行事务T2的DELETE,此时显示DELETE 0,由于事务T1未提交,事务2看不到事务插入的数据;
事务T1:
START TRANSACTION;
INSERT INTO test VALUES(1,'test1','test123');
COMMIT;
事务T2:
START TRANSACTION;
DELETE test WHERE NAME='test1';
COMMIT;
场景1:
开启事务T1,不提交的同时开启事务T2,事务T1执行INSERT完成后,执行事务T2的DELETE,此时显示DELETE 0,由于事务T1未提交,事务2看不到事务插入的数据;