MySQL TRANSACTION ISOLATION LEVEL Example


mysql > SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Query OK, 0 rows affected
Time: 0.001s
mysql >

Comments