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
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
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_table`