mysql中的隐式提交

有些语句在没有使用commit的时候，事务也会提交，这种情况称为隐式提交，ddl语句，事务语句和管理的语句都会产生隐式提交，这个跟oracle一样的。下面简单测试看看

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

est>insert into t2 values('bai',22);
Query OK, 1 row affected (0.02 sec)

test>select * from t2;
+------+------+
| name | age |
+------+------+
| xiao | 11 |
| abc | 11 |
| ddd | 10 |
| eee | 11 |
| bai | 22 |
+------+------+
5 rows in set (0.00 sec)

test>create table t5 like t2;
Query OK, 0 rows affected (0.19 sec)

test>select * from t5;
Empty set (0.01 sec)

test>insert into t2 values('xxx',33);
Query OK, 1 row affected (0.02 sec)

.test>rollback;
Query OK, 0 rows affected (0.01 sec)

test>select * from t2;
+------+------+
| name | age |
+------+------+
| xiao | 11 |
| abc | 11 |
| ddd | 10 |
| eee | 11 |
| bai | 22 |
| xxx | 33 |
+------+------+
6 rows in set (0.01 sec)

按正常的理解，应该是只有（‘bai',22)这个记录隐式提交插入了，但是因为mysql是自动提交的，所以在create table t5的时候，事务没了，后面的语句就自动提交了。

est>begin;
Query OK, 0 rows affected (0.01 sec)

test>insert into t2 values('zzz',888);
Query OK, 1 row affected (0.01 sec)

test>grant select on test.* to myadmin@'%';
Query OK, 0 rows affected (0.11 sec)

est>insert into t2 values('vvv',999);
Query OK, 1 row affected (0.02 sec)

test>rollback;
Query OK, 0 rows affected (0.00 sec)

test>select * from t2;
+------+------+
| name | age |
+------+------+
| xiao | 11 |
| abc | 11 |
| ddd | 10 |
| eee | 11 |
| bai | 22 |
| xxx | 33 |
| zzz | 888 |
| vvv | 999 |
+------+------+
8 rows in set (0.00 sec)

看到授权语句也是导致了隐式的提交。

更多相关文章

随机推荐