Re: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Josh Trutwin
r 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. >> &g

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Paul DuBois
ded 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, > >

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Steve Bradwell
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

Re: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Michael Bretterklieber
lieber [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(&#x

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Steve Bradwell
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 this

Re: [PHP-DB] Innodb and transactions.

2002-06-20 Thread Michael Bretterklieber
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 > transacti