update student set userName='杨过' where id=4;
begin;# 开启事务
update student set userName='古校长' where id=4;
select * from student where id=4;# 开启时候后不会写硬盘上
rollback;# 回滚事务
commit;# 提交事务·redo log
事务属性(GEBGIN COMMIT ROLLBACK)
![](https://img-home.csdnimg.cn/images/20240711042549.png)
update student set userName='杨过' where id=4;
begin;# 开启事务
update student set userName='古校长' where id=4;
select * from student where id=4;# 开启时候后不会写硬盘上
rollback;# 回滚事务
commit;# 提交事务·redo log