mysql> use RUNOOB;
Database changed
mysql> CREATE TABLE runoob_transaction_test( id int(5)) engine=innodb;? # 創(chuàng)建數(shù)據(jù)表
Query OK, 0 rows affected (0.04 sec)
mysql> select * from runoob_transaction_test;
Empty set (0.01 sec)
mysql> begin;? # 開(kāi)始事務(wù)
Query OK, 0 rows affected (0.00 sec)
mysql> insert into runoob_transaction_test value(5);
Query OK, 1 rows affected (0.01 sec)
mysql> insert into runoob_transaction_test value(6);
Query OK, 1 rows affected (0.00 sec)
mysql> commit; # 提交事務(wù)
Query OK, 0 rows affected (0.01 sec)
mysql>? select * from runoob_transaction_test;
+------+
| id? |
+------+
| 5? ? |
| 6? ? |
+------+
2 rows in set (0.01 sec)
mysql> begin;? ? # 開(kāi)始事務(wù)
Query OK, 0 rows affected (0.00 sec)
mysql>? insert into runoob_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 runoob_transaction_test;? # 因?yàn)榛貪L所以數(shù)據(jù)沒(méi)有插入
+------+
| id? |
+------+
| 5? ? |
| 6? ? |
+------+
2 r
