15.2、事务的提交与回滚演示 · Mysql深入浅出

### 15.2、事务的提交与回滚演示 1) 创建表 ``` create table user( id int (11) primary key not null auto\_increment , username varchar(30), password varchar(30) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ``` 2)查询表中数据 ![](https://img.kancloud.cn/51/91/5191e018cc9e974c3f93a92da060ab74_271x54.png) 3) 开启事务START TRANSACTION; 4) 插入数据 insert into user (username,password) values ('zhangsan','123'); ![](https://img.kancloud.cn/de/dd/dedd23c57bc61b0fb7df864602b497ad_613x50.png) 5) 查看数据 ![](https://img.kancloud.cn/6a/b7/6ab73b91e2093f3e9b13789bbfa37c5d_318x120.png) 6)修改数据 ![](https://img.kancloud.cn/c9/a3/c9a3de7e949b661320a365a2d2e18f1b_557x65.png) 7) 查看数据 ![](https://img.kancloud.cn/f0/30/f03045eb4adc751ae1282c2456d684cd_311x121.png) 8) 回滚事务 ![](https://img.kancloud.cn/fc/37/fc3741a3c53b3c3810829bcd0b531c86_325x48.png) 9) 查看数据 ![](https://img.kancloud.cn/6a/72/6a72f278d44a3826fc7b7745ce92c625_296x47.png)