Home  >  Article  >  Database  >  How to check the current MySQL transaction isolation level?

How to check the current MySQL transaction isolation level?

WBOY
WBOYforward
2023-09-08 10:53:061153browse

How to check the current MySQL transaction isolation level?

We can check the current MySQL transaction isolation level by executing the SELECT @@TX_ISOLATION command.

Example

mysql> SELECT @@TX_ISOLATION;
+-----------------+
| @@TX_ISOLATION  |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)

The above is the detailed content of How to check the current MySQL transaction isolation level?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete