学习笔记（1):MySQL数据库从入门到实战课-事务控制

立即学习:https://edu.csdn.net/course/play/27328/370709?utm_source=blogtoedu

create table bank_account(
id int not null auto_increment primary key,
name varchar(30) comment '姓名',
balance decimal(18,2) comment '账户余额'
);

insert into bank_account (id,name,balance) values(1,'张三',0);
insert into bank_account (id,name,balance) values(2,'李四',0);

update bank_account set balance=balance+1000 where id=1;