- 论坛徽章:
- 0
|
最佳答案:
SQL code
?
1
2
3
4
5
6
7
mysql> show variables like '%iso%';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| tx_isolation | REPEATABLE-READ |
+---------------+-----------------+
1 row in set (0.00 sec)
如果是上面这样的,执行下面的SQL
SQL code
?
1
2
mysql> set global TRANSACTION ISOLATION LEVEL READ COMMITTED ;
Query OK, 0 rows affected (0.00 sec)
SQL code
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
mysql> show variables like '%iso%';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| tx_isolation | REPEATABLE-READ |
+---------------+-----------------+
1 row in set (0.00 sec)
mysql> show global variables like '%iso%';
+---------------+----------------+
| Variable_name | Value |
+---------------+----------------+
| tx_isolation | READ-COMMITTED |
+---------------+----------------+
1 row in set (0.00 sec)
由csdn论坛
zuoxingyu2012
zuoxingyu2012
等级:
提供!特别感谢! |
|