InnoDB - Two foreign keys on the same column from one table
Posted
by makeflo
on Stack Overflow
See other posts from Stack Overflow
or by makeflo
Published on 2010-04-14T14:07:11Z
Indexed on
2010/04/14
14:23 UTC
Read the original article
Hit count: 139
Hey Guys,
i have a project table which has a image_id
field and a newsimage_id
field.
Both are linked to the image table. But InnoDB doesn't allow me to set a foreign key for
both fields to the same column (id
).
Is there a way I can do this or is it not possible? I'm using MySQL through MAMP.
Thanks in advance!!
© Stack Overflow or respective owner