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
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