Hi,
you have to do something like this:
mysql_query('SET AUTOCOMMIT=0');
mysql_query('COMMIT'); or mysql_query('ROLLBACK');
mysql_query('SET AUTOCOMMIT=1');
bye,
Steve Bradwell schrieb:
Hi all,
I have just figured out and set up my Innodb on my mysql server so I can use
transactions
So should I be using Innodb tables or BDB tables?
Thanks,
Steve.
-Original Message-
From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 2:49 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
you have to do something like
]]
Sent: Friday, June 21, 2002 2:49 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
you have to do something like this:
mysql_query('SET AUTOCOMMIT=0');
mysql_query('COMMIT'); or mysql_query('ROLLBACK');
mysql_query('SET AUTOCOMMIT=1');
bye,
Steve
Great! thanks for your help.
-Steve.
-Original Message-
From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:11 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
use InnoDB, because InnoDB supports row-level locking, and InnoDB
with COMMIT or ROLLBACK.
Thanks,
Steve.
-Original Message-
From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 2:49 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
you have to do something like this:
mysql_query('SET AUTOCOMMIT=0
Bretterklieber [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 2:49 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
you have to do something like this:
mysql_query('SET AUTOCOMMIT=0');
mysql_query('COMMIT'); or mysql_query('ROLLBACK');
mysql_query('SET
Hi all,
I have just figured out and set up my Innodb on my mysql server so I can use
transactions Begin, commit, rollback. I'm now looking for examples on how to
do this with php. I hit the php site and the best I could find was
fbsql_commit etc... is this what I'm looking for? There's no