MySQL Forums
Forum List  »  Newbie

Multiple table insertions simultaneously
Posted by: rory mullin
Date: December 20, 2011 11:10PM

Hey All,

A little help will be much appreciated!

I have a database containing 10 tables. 2 of which are "house" and "member".

When registering for the site, a user fills in a form that writes to both tables. However the "house" table needs a member_id as a foreign key.

As the member hasn't been added to the database, how do i submit the house?

The relations are:
house(1..1)---------(1..*)member

Options: ReplyQuote


Subject
Written By
Posted
Multiple table insertions simultaneously
December 20, 2011 11:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.