mysql> begin;
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('jim');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lucy');
Query OK, 1 row affected (0.00 sec)mysql> commit;
Query OK, 0 rows affected (0.01 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.01 sec)mysql> begin;
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)mysql> set auto commit=0;
ERROR 1193 (HY000): Unknown system variable 'auto'
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
| 4 | Lily |
| 5 | Lily |
| 6 | Lily |
+----+------+
5 rows in set (0.00 sec)mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('jim');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lucy');
Query OK, 1 row affected (0.00 sec)mysql> commit;
Query OK, 0 rows affected (0.01 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.01 sec)mysql> begin;
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)mysql> set auto commit=0;
ERROR 1193 (HY000): Unknown system variable 'auto'
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
| 4 | Lily |
| 5 | Lily |
| 6 | Lily |
+----+------+
5 rows in set (0.00 sec)mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)
ERROR 1193 (HY000): Unknown system variable 'auto'
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec) mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec) mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec) mysql> insert into dbtest(user) values('Lily');
Query OK, 1 row affected (0.00 sec) mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
| 4 | Lily |
| 5 | Lily |
| 6 | Lily |
+----+------+
5 rows in set (0.00 sec) mysql> rollback;
Query OK, 0 rows affected (0.03 sec) mysql> select * from dbtest;
+----+------+
| id | user |
+----+------+
| 1 | jim |
| 2 | Lucy |
+----+------+
2 rows in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)mysql> insert into test(name, num, price)values('three', 5, 10.001);
Query OK, 1 row affected (0.00 sec)mysql> insert into test(name, num, price)values('three', 5, 10.001);
Query OK, 1 row affected (0.00 sec)mysql> select * from test;
+----+--------+-----+--------+
| id | name | num | price |
+----+--------+-----+--------+
| 1 | test | 5 | 10.001 |
| 2 | first | 5 | 10.001 |
| 3 | secode | 5 | 10.001 |
| 5 | three | 5 | 10.001 |
| 6 | three | 5 | 10.001 |
+----+--------+-----+--------+
5 rows in set (0.00 sec)mysql> rollback;
Query OK, 0 rows affected (0.04 sec)mysql> select * from test;
+----+--------+-----+--------+
| id | name | num | price |
+----+--------+-----+--------+
| 1 | test | 5 | 10.001 |
| 2 | first | 5 | 10.001 |
| 3 | secode | 5 | 10.001 |
+----+--------+-----+--------+
3 rows in set (0.00 sec)mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)mysql> insert into test(name, num, price)values('three', 5, 10.001);
Query OK, 1 row affected (0.00 sec)mysql> commit;
Query OK, 0 rows affected (0.03 sec)mysql> select * from test;
+----+--------+-----+--------+
| id | name | num | price |
+----+--------+-----+--------+
| 1 | test | 5 | 10.001 |
| 2 | first | 5 | 10.001 |
| 3 | secode | 5 | 10.001 |
| 7 | three | 5 | 10.001 |
+----+--------+-----+--------+
4 rows in set (0.00 sec)---------------------------------------------------------------
回滚后自增列居然是一直增加的 —_—