You are right, though not sure where, I remember seeing that they are available in BDB tables, though now I know it's false after looking at mysql docs.
Thanks. Ilya -----Original Message----- From: [EMAIL PROTECTED] To: Sterin, Ilya Cc: 'Vuillemot, Ward W '; '[EMAIL PROTECTED] ' Sent: 10/30/01 8:52 AM Subject: Re: MySQL and Foreign keys 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
