事务的开启回滚 提交

mysql> use chapter06;
Database changed

mysql> CREATE TABLE account(
-> id INT primary key auto_increment,
-> name VARCHAR(40),
-> money FLOAT
-> )ENGINE=InnoDB;
Query OK, 0 rows affected

mysql> INSERT INTO account(name,money)VALUES(‘a’,1000);
Query OK, 1 row affected

mysql> INSERT INTO account(name,money)VALUES(‘b’,1000);
Query OK, 1 row affected

mysql> SELECT * FROM account;
±—±-----±------+
| id | name | money |
±—±-----±------+
| 1 | a | 1000 |
| 2 | b | 1000 |
±—±-----±------+
2 rows in set
//开启事务的语句
mysql> START TRANSACTION;
Query OK, 0 rows affected
//a向b账户转账100元
mysql> UPDATE account SET money=money-100 WHERE NAME=‘a’;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE account SET money=money+100 WHERE NAME=‘b’;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM account;
±—±-----±------+
| id | name | money |
±—±-----±------+
| 1 | a | 900 |
| 2 | b | 1100 |
±—±-----±------+
2 rows in set
//显示结果在三表示没有转账成功
结论：在事务中转账成功后没有提交事务就退出了数据库，由于事务中的语句不能自动提交，因此当前的操作会被自动取消。
提交事务语句，COMMIT
//开启事务
mysql> START TRANSACTION;
Query OK, 0 rows affected
//a向b转入100元
mysql> UPDATE account SET money=money-100 WHERE NAME=‘a’;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE account SET money=money+100 WHERE NAME=‘b’;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM account;
±—±-----±------+
| id | name | money |
±—±-----±------+
| 1 | a | 700 |
| 2 | b | 1300 |
±—±-----±------+
2 rows in set
//回滚事务 ，当前事务中的操作取消了
mysql> ROLLBACK;
Query OK, 0 rows affected

mysql> SELECT * FROM account;
±—±-----±------+
| id | name | money |
±—±-----±------+
| 1 | a | 800 |
| 2 | b | 1200 |
±—±-----±------+
2 rows in set
在MySQL中，事务有四种隔离级别，接下来将针对这四种隔离级别进行详细地讲解。
（1）READ UNCOMMITTED（读未提交）
（2）READ COMMITTED（读提交）
（3）REPEATABLE READ（可重复读）
（4）SERIALIZABLE（可串行化）