SQL
# sql-1select Population from city where District ='Kabol';# sql-2update city set Population=Population+1 where District ='Kabol';
默认事务隔离级别R-R
|
Transactional-1 |
Transactional-2 |
| Time-1 |
sql-1 |
|
| Time-2 |
sql-2 |
|
| Time-3 |
|
sql-2 |
| Time-4 |
sql-1 |
|
|
sql-1查询的最终结果 |
|
Transactional-1 |
Transactional-2 |
| Time-1 |
sql-1 |
|
| Time-2 |
|
|
| Time-3 |
|
sql-2 |
| Time-4 |
sql-1 |
|
|
sql-1查询的最终结果 |
事务隔离级别R-C
|
Transactional-1 |
Transactional-2 |
| Time-1 |
sql-1 |
|
| Time-2 |
sql-2 |
|
| Time-3 |
|
sql-2 |
| Time-4 |
sql-1 |
|
|
sql-1查询的最终结果 |
|
Transactional-1 |
Transactional-2 |
| Time-1 |
sql-1 |
|
| Time-2 |
|
|
| Time-3 |
|
sql-2 |
| Time-4 |
sql-1 |
|
|
sql-1查询的最终结果 |
