我mysql的isolation level设置的是REPEATABLE-READ,我开两个session,session1执行如下语句:
use HRSystem;
start transaction;
select * from Persons where name="hello";
然后session2执行如下语句:
use HRSystem;
start transaction;
update Persons set city="Hangzhou" where name="hello";
居然session2不会block,然后在session1再次执行select,居然能看到最新的更改结果,怎么回事?mysql
use HRSystem;
start transaction;
select * from Persons where name="hello";
然后session2执行如下语句:
use HRSystem;
start transaction;
update Persons set city="Hangzhou" where name="hello";
居然session2不会block,然后在session1再次执行select,居然能看到最新的更改结果,怎么回事?mysql
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货