On Wed, 13 Oct 2004 15:26:12 -0500, dpgirago@xxxxxxxxxxxxxx <dpgirago@xxxxxxxxxxxxxx> wrote: > right, so after you define the fields of the table, you add type=innodb > simple as that > > dave > > > Gerard Samuel <php-db@xxxxxxxxxx> > > 10/13/2004 02:34 PM > > To: > jon@xxxxxxxxxxxxxxxxx > cc: > php-db@xxxxxxxxxxxxx, julian@xxxxxxxxxxx > > > Subject: > Re: INNO tables - will I have problems? > > jon@xxxxxxxxxxxxxxxxx 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
