RE: [PHP-DB] Foreign Key in MySQL

Although missing CASCADE, vers 4.0 does have UNION. Still missing sub-selects, though. -----Original Message----- From: Rick Emery [mailto:remery@excel.com] Sent: Wednesday, October 17, 2001 8:59 AM To: 'php-db@lists.php.net' Subject: RE: [PHP-DB] Foreign Key in MySQL Why not??? Let me count the reasons... 1. vers 4.0 was released only 2 days ago 2. vers 4.0 release is alpha version 3. vers 4.0 is unstable, that is, subject to change as the developers create BETA version 4. vers 4.0 would NOT be a wise choice for mission-critical applications until stability is resolved 5. According to the updated vers 4.0 manual, FOREIGN keys are not mentioned as added 6. According to the updated vers 4.0 manual, CASCADE are not mentioned as added -----Original Message----- From: Sommai Fongnamthip [mailto:sommai@thaithanakit.co.th] Sent: Wednesday, October 17, 2001 8:51 AM To: Rick Emery Subject: Re: [PHP-DB] Foreign Key in MySQL (was: Newbie Question: Convert SELECT to DEL ETE) Why did not try MySQL 4.0??? SF At 08:08 17/10/2001 -0500, you wrote: >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 -- 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