The difference of Isolation level – Read Committed vs Repeatable Read

MySQL's default isolation level is "Repeatable Read". But Oracle's default isolation level is "Read Committed". In this post, I will show you the difference by example. Test environment : MySQL 5.7 Test table Test scenario 1 - Read Committed Seq Session 1 Session 2 1 set session transaction isolation level read committed; start transaction; set …