Re: INNO tables - will I have problems?

On Wed, 13 Oct 2004 15:26:12 -0500, dpgirago@mdanderson.org <dpgirago@mdanderson.org> wrote: > right, so after you define the fields of the table, you add type=innodb > simple as that > > dave > > > Gerard Samuel <php-db@trini0.org> > > 10/13/2004 02:34 PM > > To: > jon@oldirtyhaddad.com > cc: > php-db@lists.php.net, julian@madle.co.uk > > > Subject: > Re: [PHP-DB] INNO tables - will I have problems? > > jon@oldirtyhaddad.com 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