On Tue, 25 Nov 2003, Tim Bunce wrote:

> [The mysql situation is a little blurred here but I'd expect setting
> AutoCommit to 0 to not be an error for DBD::mysql, but (hopefully)
> commit() could warn if there's no in-transaction-state to commit.
> But I digress...]
> 

I don't know.  A quick test does not make it seem likely:

mysql> create table test_1 (foo int);
Query OK, 0 rows affected (0.27 sec)

mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test_1 values (1);
Query OK, 1 row affected (0.37 sec)

mysql> commit;
Query OK, 0 rows affected (0.04 sec)

mysql> insert into test_1 VALUES(0);
Query OK, 1 row affected (0.00 sec)

mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)



Rudy

Reply via email to