# repeatable-read是如何解决幻读的

本文将介绍可重复读是如何解决幻读的

# 幻读出现的场景

session A

set session transaction isolation level repeatable read;

begin;

select * from t where d=5 for update;

# commit

session B

set session transaction isolation level repeatable read;

update t set d=5 where id=0;

# commit;