MySQL Forums
Forum List  »  MySQL Query Browser

Re: Relationship between tables
Posted by: Fiona Olsen
Date: April 13, 2005 02:49PM

Yes, I have one question.

How do you enter the data into the two tables?
are you using:

insert into customer (id,column2)
values('','example');
insert into item_sales (id,column3)
values(CURRENT_ID(),'examples');

Or are you doing it another way?

The point is to get the same id on the two tables, but HOW to you accomplish that?

Options: ReplyQuote


Subject
Written By
Posted
Re: Relationship between tables
April 13, 2005 02:49PM


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.