- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we check the current MySQL transaction isolation level?
By executing SELECT @@TX_ISOLATION command we can check the current MySQL transaction isolation level.
Example
mysql> SELECT @@TX_ISOLATION; +-----------------+ | @@TX_ISOLATION | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec)
Updated on 22-Jun-2020 11:43:36
- Related Questions & Answers
- How can we find out the current transaction mode in MySQL?
- How can we implement a MySQL transaction?
- How can a user explicitly end current MySQL transaction?
- How can a user implicitly end current MySQL transaction?
- How changes, made in the current transaction, can be permanently recorded in MySQL database?
- How changes, made in the current transaction, can be permanently eliminated from MySQL database?
- What are different transaction isolation levels in DBMS?
- What are the transaction isolation levels supported by JDBC API?
- What will happen to the current MySQL transaction if a START TRANSACTION command is executed in the middle of that current transaction?
- What happens to the current MySQL transaction if the session is ended in the middle of a transaction?
- How can a user start new MySQL transaction?
- What will happen to MySQL current transaction, if in the middle of that transaction, the DDL statement is executed?
- How can we check for NULL in a MySQL query?
- What happens to the current MySQL transaction if the session is killed by DBA?
- How can we insert current date automatically in a column of MySQL table?
Advertisements