Inserting into mySQL table with a foreign key that hasn't been created yet.
Posted
by ranzy
on Stack Overflow
See other posts from Stack Overflow
or by ranzy
Published on 2010-04-09T20:36:44Z
Indexed on
2010/04/09
20:43 UTC
Read the original article
Hit count: 270
sql
|phpmyadmin
Okay I have two tables. They both have keys. I have another table that references both keys. How can I make a constraint when I add into that third if either of the keys don't exist in the first two tables it won't insert that tuple into the third table. I am inserting in phpMyAdmin. Thanks.
© Stack Overflow or respective owner