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

Reply via email to