How to insert into two tables that have Foreign Keys Referencing each other.

[shreedhan]

I have two tables table1 and table2
Table1 has a foreign key which references key of table2
Table2 also has a foreign key which references key of table1

Now when I try to insert into any of those 2 tables, violation of foreign key occurs.
How can I insert into both tables without violating foreign key

Is there any way to insert both tables simultaneously?

thanks

[Atli]

Hi.

I would have thought this could not happen.

How did you manage to create the first table with a Foreign Key referencing a second table when the second table didn't exists? That should have caused an error.

[pbmods]

Heya, Shreedhan.

The solution is to remove one of your foreign key constraints.

If that doesn't make sense for your database design, then you probably need to rethink your database design.

[shreedhan]

Thanks for your reply

I am now removing the foreign key, because its not very significant.

And, Atli
I created first table without any foreign key
then I created the second one having foreign key referencing the first one
After that I altered the first table to add the foreign key referencing the second one.

Thanks

[Atli]

I created first table without any foreign key
then I created the second one having foreign key referencing the first one
After that I altered the first table to add the foreign key referencing the second one.

Ahh ok. So you basically bypassed the built in protection against the very problem you encountered :)

Maybe it should be submitted as a MySQL bug...

Anyways, good luck with you project!

P.S. I changed the title of the thread to make it more descriptive.