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
> Gerard Samuel <[EMAIL PROTECTED]>
> 10/13/2004 02:34 PM
> [EMAIL PROTECTED]
> [EMAIL PROTECTED], [EMAIL PROTECTED]
> 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...
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