RE: [PHP-DB] Re: Foreign Key in MySQL (was: Newbie Question: Conv ert SELECT to DEL ETE)

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:Heikki.Tuuri@innobase.inet.fi] Sent: Thursday, October 18, 2001 3:35 PM To: php-db@lists.php.net 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:remery@excel.com] >Sent: Wednesday, October 17, 2001 6:09 AM >To: php-db@lists.php.net >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:ted@acacia.datacomm.com] >Sent: Tuesday, October 16, 2001 6:37 PM >To: Sheila Myers >Cc: php-db@lists.php.net >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: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net