数据库的隔离级别

隔离级别                          是否存在脏读         是否存在不可重复读   是否存在幻读
(Read Uncommited)              Y                                Y                                Y
(Read Commited)                  N                                Y                                Y
(Repeatable Read)(相当于加了悲观锁)   N                 N                              Y 
(Seriazble)                             N                                  N                              N


mySql             select @@tx_isolation;   查看mysql数据库的隔离级别

set transaction  isolation level  read uncommitted;    设置隔离级别为未提交读