I believe it only supports FK's with InnoDB table handlers, not BDB, with the recent release of 4.0 alpha... which is extermely "Buggy"... :)
>>On Tue, 30 Oct 2001 08:48:42 -0700, "Sterin, Ilya" <[EMAIL PROTECTED]> wrote: >>This is not DBI related, so please post to appropriate list. >> >>MySQL did not support foreign keys until recently, and even now it's limited >>to BDS tables. >> >>Ilya >> >>-----Original Message----- >>From: Vuillemot, Ward W >>To: [EMAIL PROTECTED] >>Sent: 10/30/01 8:37 AM >>Subject: MySQL and Foreign keys >> >>I would like to know how people handle foreign keys with mysql. >>Has anyone ever created a relationships table for use with other tables? >>If >>so, what types of fields did you find necessary to define the >>relationships? >>How did you handle parent-child relationships -- when parents are >>deleted >>all their children must also be deleted. . .I would really to learn what >>types of experiences have had. >> >>Thanks in advance, >>Ward Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
