MYSQL 事务处理主要有两种方法

1、用 BEGIN, ROLLBACK, COMMIT来实现

BEGIN 开始一个事务

ROLLBACK 事务回滚

COMMIT 事务确认

mysql> use DEMO;
Database changed
mysql> CREATE TABLE demo_transaction_test( id int(5)) engine=innodb; # 创建数据表
Query OK, 0 rows affected (0.04 sec)
mysql> select * from demo_transaction_test;Empty set (0.01 sec)
mysql> begin; # 开始事务Query OK, 0 rows affected (0.00 sec)
mysql> insert into demo_transaction_test value(5);Query OK, 1 rows affected (0.01 sec)
mysql> insert into demo_transaction_test value(6);Query OK, 1 rows affected (0.00 sec)
mysql> commit; # 提交事务
Query OK, 0 rows affected (0.01 sec)
mysql> select * from demo_transaction_test;
+------+
| id |
+------+
| 5 |
| 6 |
+------+2 rows in set (0.01 sec)
mysql> begin; # 开始事务
Query OK, 0 rows affected (0.00 sec)
mysql> insert into demo_transaction_test values(7);
Query OK, 1 rows affected (0.00 sec)
mysql> rollback; # 回滚
Query OK, 0 rows affected (0.00 sec)
mysql> select * from demo_transaction_test; # 因为回滚所以数据没有插入+------+
| id |
+------+
| 5 |
| 6 |
+------+2 rows in set (0.01 sec)
mysql>

 

2、直接用 SET 来改变 MySQL 的自动提交模式:

文章来自 www.hezhidz.com