- 论坛徽章:
- 0
|
- mysql> begin;
- Query OK, 0 rows affected (0.00 sec)
- mysql> insert into dbtest value(5);
- Query OK, 1 row affected (0.00 sec)
- mysql> insert into dbtest value(6);
- Query OK, 1 row affected (0.00 sec)
- mysql> commit;
- Query OK, 0 rows affected (0.00 sec)
- mysql> select * from dbtest;
- +------+
- | id |
- +------+
- | 5 |
- | 6 |
- +------+
- 2 rows in set (0.00 sec)
- mysql> begin;
- Query OK, 0 rows affected (0.00 sec)
- mysql> insert into dbtest values(7);
- Query OK, 1 row affected (0.00 sec)
- mysql> rollback;
- Query OK, 0 rows affected, 1 warning (0.00 sec)
- mysql> select * from dbtest;
- +------+
- | id |
- +------+
- | 5 |
- | 6 |
- | 7 |
- +------+
复制代码
mysql version : Server version: 5.0.51b
小弟对数据库不是很懂,我也是过了 set AUTOCOMMIT=0, 好像也不行。表的TYPE已经是INNODB了, 哪位能告诉我正确的方法吗? 还是我mysql 设置的不对。
[ 本帖最后由 squallabc 于 2009-5-21 14:36 编辑 ] |
|