mysql 事务的写法与使用

事务的ACID特性:

在这片文章中给了详细的解释

http://blog.csdn.net/chosen0ne/article/details/10036775

A:atomicity 原子性

C:Consistency  一致性

I: Isolation 隔离性

D:durabiliity 可靠性

事务的基本写法

查看表引擎命令

 show engines;

innodb支持事务,myisam不支持事务

事务的开启:

begin或者start transaction

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> update goodsorder set much=7 where id=5;
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> select * from goodsorder;
+----+-----+------+
| id | gid | much |
+----+-----+------+
|  2 |   1 |    1 |
|  3 |   1 |    1 |
|  4 |   1 |    1 |
|  5 |   3 |    7 |
|  6 |   1 |   15 |
|  7 |   1 |    3 |
+----+-----+------+
6 rows in set (0.00 sec)

mysql> rollback;

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from goodsorder where id=7;
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql> update goodsorder set much=10 where id=6;
Query OK, 1 row affected, 1 warning (0.00