SQL-基础--事务

create table account(
		id int primary key auto_increment,
		name varchar(32),
		money double(14,2)
);

insert into account(name,money) VALUES
('张三',1000),
('李四',1000);

select id,name,money from account;
UPDATE account set money = 1000;

begin; -- 开启事务
UPDATE account set money = money - 500 WHERE name = '李四';
UPDATE account set money = money + 500 WHERE name = '张三';

COMMIT; -- 提交事务

ROLLBACK; -- 回滚事务