mysql 如何设置事务隔离级别

2024-10-12 17:00:59

1、查看当前事物级别：SELECT @@tx_isolation;

2、设置mysql的隔离级别：set session transaction isolation level 设置事务隔离级别

3、设置read uncommitted级别：set session transaction isolation level read uncommitted;查看设置结果：SELECT @@tx_isolation;

4、设置read committed级别：set session transaction isolation level read committed查看设置结果：SELECT @@tx_isolation;

5、设置repeatable read级别：set session transaction isolation level repeatable read;查看设置结果：SELECT @@tx_isolation;

6、设置serializable级别：set session transaction isolation level serializable查看设置结果：SELECT @@tx_isolation;