mysql 也有事务处理,只是一直都不知道怎么用,今天试试还行, 执行 begin 然后输入一组sql语句 最后执行commit 命令 刚才的sql语句才执行 如果执行了rollback后刚才的sql就都没有执行
mysql> select * from nesw;
+------+------+
| id | sp |
+------+------+
| 12 | 1 |
| 1 | 1 |
| 1 | 3 |
| 1 | 4 |
+------+------+
4 rows in set (0.00 sec)
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into nesw values(1,10);
Query OK, 1 row affected (0.02 sec)
mysql> insert into nesw values(1,11);
Query OK, 1 row affected (0.00 sec)
mysql> rollback;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from nesw;
+------+------+
| id | sp |
+------+------+
| 12 | 1 |
| 1 | 1 |
| 1 | 3 |
| 1 | 4 |
+------+------+
4 rows in set (0.00 sec)
mysql>