On Thu, 22 Jul 2004 12:14:58 -0400
Roy Harrell <[EMAIL PROTECTED]> wrote:
> Can a child table have multiple foreign key references linking
> its records to two or more parent tables?
yes - something like:
CREATE TABLE child (
p1_id INT,
p2_id INT,
INDEX p1_id_ind (p1_id),
INDEX p2_id
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 list
On Saturday 08 March 2003 02:27, Daevid Vincent wrote:
> Can I have multiple foreign keys in a table? Like this... I ask because I
> can't seem to get it to work. Errno: 150.
Yes, you can. Check that all tables are InnoDB, that columns have the same
type and so on ..
>
> CREATE TABLE `dept_tabl
