RE: Foreign Key in MySQL (was: Newbie Question: Convert SELECT to DEL ETE)

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