The answer is "yes" to all of your questions. Just as an example, I have a table in one of my databases that is a "child" to nine other tables and is the "parent" to two. Just remember that any child table columns participating in a FK relationship must also be indexed (or the first column listed in a compound index) and only InnoDB tables can participate in FK relationships. (I experienced both of those "gotchas" when I was getting started :- )
Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Roy Harrell <[EMAIL PROTECTED]> wrote on 07/22/2004 12:14:58 PM: > Can a child table have multiple foreign key references linking > its records to two or more parent tables? > > Can a parent table also be a child table? That is, can a parent > table have a foreign key that links it to another table? > > > I setting up my tables as INNODB types. > > Thanks, > > Roy Harrell > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
