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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
RE: [PHP-DB] Innodb and 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 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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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:[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 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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
RE: [PHP-DB] Innodb and transactions.
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 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:[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 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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Innodb and transactions.
At 8:55 -0400 6/21/02, Steve Bradwell wrote:
So should I be using Innodb tables or BDB tables?
You have to be using *some* kind of transaction-safe tables (InnoDB
and BDB qualify). If you use a table type like MyISAM, then all
statements are committed as they execute, and use of a transaction
has no meaning.
Also, another way to perform a transaction (besides that shown below)
is to use BEGIN to begin it and COMMIT or ROLLBACK to end it.
The difference is that you don't need to modify the AUTOCOMMIT
mode explicitly; BEGIN suspends it temporarily until the transaction
has been ended 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');
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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
Re: [PHP-DB] Innodb and transactions.
One other obvious thing to remember is that you need to to use:
create table (int id blah blah blah) type = InnoDB;
Also, to take advantage of these features you will also need to update
your /etc/my.cnf file (assuming you run some *nix flavored OS) so the
InnoDB files are created on disk. I found that very slowly reading
through the online docs at mysql.com/doc (see section 7.5.2) was adequate
to get started. If you don't do this step and you try to create a InnoDB
table, MySQL will just create a regular MyISAM table, but it won't even
tell you it did that! Not very helpful. You can execute a SHOW TABLE
STATUS to see what kind of table MySQL really created though.
FYI, MySQL 3.23.51 also has InnoDB support for Foriegn Keys and Delete On
Cascade, something I'm really excited to finally see in MySQL.
Anyway, enough blabber. Hope you enjoy InnoDB, it's a little tough to get
going, but solid once it's setup.
Josh
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:[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 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
[EMAIL PROTECTED]
homepage: http://www.jawa.at
- privat ---
E-mail: [EMAIL PROTECTED]
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
Josh Trutwin
http://trutwins.homeip.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
