REPEATABLE READ

Learn repeatable reads.

REPEATABLE READ ensures re-reading a row gives the same value. It prevents non-repeatable reads.

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

No non-repeatable read, phantom exists.

REPEATABLE READ — details

Phantom read: new rows may be added, the same query may return more rows.

For example, if you count orders twice with COUNT(*), the second count can differ when another transaction inserts a new order in between.

Set the isolation level to REPEATABLE READ.

Show example solution

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

REPEATABLE READ

SET TRANSACTION ISOLATION LEVEL ____

Show answer

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

Next lesson: SERIALIZABLE