SELECT * FROM tc_smu_file
WHERE tc_smu04 = 1
AND tc_smu05 = 10000
FOR UPDATE NOWAIT 锁定资料后,用SELECT * FROM tc_smu_file
WHERE tc_smu04 = 10001
AND tc_smu05 = 20000
FOR UPDATE NOWAIT查询时怎么也会提示资料被锁呢?
数据库是采用的行锁.用tc_smu04,tc_smu05查询出来的资料是不同的.所以应该是这两个语句 只锁定查出来的结果吧?
WHERE tc_smu04 = 1
AND tc_smu05 = 10000
FOR UPDATE NOWAIT 锁定资料后,用SELECT * FROM tc_smu_file
WHERE tc_smu04 = 10001
AND tc_smu05 = 20000
FOR UPDATE NOWAIT查询时怎么也会提示资料被锁呢?
数据库是采用的行锁.用tc_smu04,tc_smu05查询出来的资料是不同的.所以应该是这两个语句 只锁定查出来的结果吧?
用的是什么事务隔离级?可串行化?