Prior to version 4.0, INNODB was compiled in only the mysql-max binary, not
the standard binary.  Most web-hosts, and virtual web-hosting companies, do
not run the -MAX version.  Therefore, there was no access to innodb
databases.

As we stated in threads yesterday, version 4.0 is not ready for prime time.
It was an ALPHA release (read: bug-ridden) and is unstable (under
development).  This is NOT the version you want to use for mission-critical
applications.

When version 4.x, golden version, is released, then it might be usable.
Along with INNODB.

-----Original Message-----
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Foreign Key in MySQL (was: Newbie Question:
Convert SELECT to DEL ETE)


Hi!

MySQL-3.23.44 and MySQL-4.0.0 support foreign keys
through transactional InnoDB type tables.

See http://www.innodb.com for more info.

Regards,

Heikki
Innobase Oy

Rita Mikusch wrote in message
<10C5C8152BD5D31181AC006008AD5F416886AD@NEWCA2>...
>Foreign Keys? No such luck! You need to check the for the child records,
>then delete them if they exist.
>
>rita.
>
>-----Original Message-----
>From: Rick Emery [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, October 17, 2001 6:09 AM
>To: [EMAIL PROTECTED]
>Subject: Foreign Key in MySQL (was: Newbie Question: Convert SELECT to
>DEL ETE)
>
>
>MySQL also does not support FOREIGN keys.  The term "FOREIGN KEY" is
>accepted in the syntax, but it is ignored.
>
>-----Original Message-----
>From: Ted Rolle [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, October 16, 2001 6:37 PM
>To: Sheila Myers
>Cc: [EMAIL PROTECTED]
>Subject: Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE
>statement in mysql
>
>
>MySQL doesn't have a CASCADE option AFAIK; PostgreSQL does.B
>
>On Tue, 16 Oct 2001, Sheila Myers wrote:
>
>> I haven't done a lot of mySql, but does it have a 'cascade' option when
>> you're creating tables?  This allows you to define a foreign key
>> relationship, so that when you delete your master record, the associated
>> child records are also deleted.
>>
>> Sheila
>>
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to