事务A,事务B:
事务A | 事物B |
---|---|
start transaction | - |
- | start transaction |
select * from course(1) | - |
- | select * from course(2) |
insert into course values (‘04’, ‘CS’, ‘03’) | - |
select * from course(3) | - |
- | select * from course(4) |
commit | - |
- | select * from course(5) |
- | commit |
- | select * from course(6) |
发现:
(1)和(2)中我们会看到insert之前的表:
CID | Cname | TID |
---|---|---|
01 | Chinese | 02 |
02 | Math | 09 |
03 | English | 04 |