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
