READ COMMITTED(提交读):一个事务开始时,只能看见已经提交的事务所作的修改,换言之,就是只要该事务没有提交,其他事务是无法看见本事务已经做的修改...
基于648个网页-相关网页
提交读,未提交读,可重复读,可串行读。
Read committed, Read uncommitted, Repeatable Read, Serializable.
比如,读取只读的查找表不需要可重复读级别,未提交读级别就足够了。
For example, reading from a read - only look up table doesn t require repeatable read, and uncommitted read is sufficient.
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
应用推荐