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

Filed under:
|
|

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

Related posts about innodb

Related posts about mysql