RE: [PHP-DB] Innodb and transactions.
| From: | Steve Bradwell | Date: | Fri, 21 Jun 2002 13:15:32 +0000 |
| Subject: | RE: [PHP-DB] Innodb and transactions. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19951@lists.php.net to get a copy of this message | ||
Great! thanks for your help.
-Steve.
-----Original Message-----
From: Michael Bretterklieber [mailto:mbretter@jawa.at]
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 also
supports referential-integrity,
bye,
Steve Bradwell schrieb:
> So should I be using Innodb tables or BDB tables?
>
> Thanks,
> Steve.
>
> -----Original Message-----
> From: Michael Bretterklieber [mailto:mbretter@jawa.at]
> 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 Bradwell schrieb:
>
>>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 documentation
>>yet. I'm using php4 with mysql 3.23.49-max, and my tables are Innodb.
>>
>>I appologize if my lingo is somewhat confusing or just wrong but I'm
>
> pretty
>
>>new to this stuff.
>>
>>Any input or examples would be greatly appreciated.
>>
>>Thanks,
>>Steve.
>>
>>
>
>
>
--
--------------------------------------
Michael Bretterklieber
LCP
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
Michael.Bretterklieber@jawa.at
homepage: http://www.jawa.at
--------- privat -----------
E-mail: mbretter@inode.at
homepage: http://www.inode.at/mbretter
--------------------------------------
"...the number of UNIX installations has grown to 10, with more expected..."
- Dennis Ritchie and Ken Thompson, June 1972
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php