Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To View and Change the Current Transaction Isolation Level
How To View and Change the Current Transaction Isolation Level? - MySQL FAQs - Transaction Management: Commit or Rollback
✍: FYIcenter.com
If you want to view or change the current transaction isolation level, you can use the following commands:
The tutorial exercise below shows you how to view and change transaction isolation level:
>\mysql\bin\mysql -u dev -piyf fyi mysql> SELECT @@TX_ISOLATION FROM DUAL; +-----------------+ | @@TX_ISOLATION | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.46 sec) mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED; Query OK, 0 rows affected (0.10 sec) mysql> SELECT @@TX_ISOLATION FROM DUAL; +----------------+ | @@TX_ISOLATION | +----------------+ | READ-COMMITTED | +----------------+ 1 row in set (0.02 sec)
2007-05-11, 5177👍, 0💬
Popular Posts:
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...
How does ASP.NET maintain state in between subsequent request ? Refer caching chapter.