select @@autocommit;
set @@autocommit = 0; --设置为手动提交,此时执行完语句必须要执行commit,因为此时不会自动提交
-- 1、查询张三账户余额
select *from account where name = '张三';
-- 2、将张三账户余额 -1000
update account set money = money -1000 where name ='张三';
-- 3、将李四账户余额+1000
update account set money = money + 1000 where name =' 李四';