先查看事务的默认提交方式:
select @@autocommit;#1代表自动提交,0代表手动提交
修改默认提交方式:
set @@autocommit=0;
注意:Oracle默认是手动提交事务。
rollback只能回退增删改语句。insert update delete
5)使用了事务操作的转账例子:
createtable account(
id intprimarykeyauto_increment,
name varchar(10),
balance double);insertinto account (name,balance)values('zhangsan',1000),('lisi',500);#张三给李四转账500元#0.开启事务STARTTRANSACTION;#1.查询张三的账户余额是否大于500#select * from account;#2.张三账户-500update account set balance = balance -500where name ='zhangsan';#3.李四账户+500#添加错误语句,模拟出错
sahsafaf
update account set balance = balance +500where name ='lisi';#发现执行没有问题,提交事务COMMIT;#发现出问题了,回滚事务ROLLBACK;