Transaction isolation level and related settings in mysql

After entering the mysql management interface, you can run the following SQL

[SQL] select @ tx_isolation; // view the isolation level set transaction isolation level read uncommitted; // set the read uncommitted level start transaction; // open the transaction rollback; // roll back the commit; // submit the set transaction isolation level read committed; // set the read submission level set transaction isolation level repeatable read; // set the repeatable read (default ), ensure that the result of each read is the same set transaction isolation level serializable; // set to serialization (similar to oracle locks)

 

The following describes the isolation level and features of transactions.