On Wed, 13 Oct 2004 15:26:12 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > right, so after you define the fields of the table, you add type=innodb > simple as that > > dave > > > Gerard Samuel <[EMAIL PROTECTED]> > > 10/13/2004 02:34 PM > > To: > [EMAIL PROTECTED] > cc: > [EMAIL PROTECTED], [EMAIL PROTECTED] > > > Subject: > Re: [PHP-DB] INNO tables - will I have problems? > > [EMAIL PROTECTED] wrote: > >>If the minimum requirement of mysql is version 4, then you > >>will have no problems, as INNODB is the default type in mysql 4.x.x > >> > >>-- > > > > > > InnoDB is included by default in mysql 4 but the default is still MyISM. > > > > I looked over the manual, and I believe that you are correct. > The default type is still MyISAM, but to create an INNODB table, one > must specify it in the CREATE TABLE syntax...
You can convert very easily afterwards also. Just a matter of a couple of lines of sql. You will have to add all the extra constraints and functionality after too... Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php