Re: [PHP-DB] INNO tables - will I have problems?
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
Re: [PHP-DB] INNO tables - will I have problems?
Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our product will specify that Linux, PHP4, and MySQL4 (or higher) are installed. The manual says that these are built-in on version 4.0 and above - I just need real-world confirmation from people with more experience in this area than me. 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] INNO tables - will I have problems?
To quote the Mighty Gerard Samuel [EMAIL PROTECTED]: Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our product will specify that Linux, PHP4, and MySQL4 (or higher) are installed. The manual says that these are built-in on version 4.0 and above - I just need real-world confirmation from people with more experience in this area than me. 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] INNO tables - will I have problems?
[EMAIL PROTECTED] 10/13/2004 12:11 PM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] INNO tables - will I have problems? To quote the Mighty Gerard Samuel [EMAIL PROTECTED]: Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our product will specify that Linux, PHP4, and MySQL4 (or higher) are installed. The manual says that these are built-in on version 4.0 and above - I just need real-world confirmation from people with more experience in this area than me. 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. make that MyISAM -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] INNO tables - will I have problems?
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... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
