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
