目录
一、新建数据库
create database chapter06;
use chapter06;
create table account(
-> id int primary key auto_increment,
-> name varchar(40),
-> money float
-> );
insert into account(name,money) values
-> ('a',1000),
-> ('b',1000);
二、事务的提交
start transaction;
update account set money=money-100 where name='a';
-> update account set money=money+100 where name='b';
commit;/