DDL
insert into student values(0,'2024-02-25 10:10:10','赵灵儿','123',
'15612345678',16,'女','逍遥哥哥,你终于找到我了。');
insert into student values(0,'2024-02-25 10:10:10','王语嫣','123',
'15612345678',17,'女','慕容复,我和你不共戴天。');
insert into student values(0,'2024-02-25 10:10:10','龙姑娘','123',
'15612345678',22,'女','我想过过过儿过过的日子。');
insert into student values(0,'2024-02-25 10:10:10','杨过','123',
'15612345678',18,'男','一遇杨过误终身。');
insert into student values(0,'2024-02-25 10:10:10','杨逍','123',
'15612345678',27,'男','杨过跟程英的大儿子。');
insert into student (userName,age,introduce)values('黄衣女子',26,'杨过与龙姑娘的大女儿。');
开启事务begin
提交事务commit
回滚(撤销)事务rollback
update student set userName='杨逍' where id=5;
#开启事务
begin;#开启事务之后所有的操作都在内存中,硬盘未写入
update student set userName='流氓一般的渣男' where id=5;
select * from student where id=5;
update student set userName='杨大渣男' where id=4;
select * from student where id=4;
rollback;#回滚操作,取消事务
commit;#提交操作,将数据通过io的方式写入硬盘。
运行完成后的表