mysql> SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; Query OK, 0 rows affected (0.04 sec) mysql> START TRANSACTION; Query OK, 0 rows affected (0.02 sec) mysql> SELECT * FROM users; +----+---------+ | id | name | +----+---------+ | 1 | TungNT | | 2 | VienLD | | 3 | CuongPT | +----+---------+ 3 rows in set (0.08 sec)