Hi,
I'm have working knowledge on MYSQL and am trying to have transactions in my php scripts.
I tried the advice for having transactions in MYSQL via the postings in this forum but have been hit with a problem, hope someone can point me in the right direction. It didn't allow me to do a rollback.
Here's the set of cmds I executed.
mysql> CREATE table test (id INT(8)) TYPE = BDB;
Query OK, 0 rows affected (0.01 sec)
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(12);
Query OK, 1 row affected (0.00 sec)
mysql> rollback;
ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled b
ack
Please let me know.
Thanks.
Martin
I'm have working knowledge on MYSQL and am trying to have transactions in my php scripts.
I tried the advice for having transactions in MYSQL via the postings in this forum but have been hit with a problem, hope someone can point me in the right direction. It didn't allow me to do a rollback.
Here's the set of cmds I executed.
mysql> CREATE table test (id INT(8)) TYPE = BDB;
Query OK, 0 rows affected (0.01 sec)
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(12);
Query OK, 1 row affected (0.00 sec)
mysql> rollback;
ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled b
ack
Please let me know.
Thanks.
Martin