MySQL Forums
Forum List  »  Newbie

Update query problems
Posted by: tyson crouch
Date: April 11, 2010 01:43AM


I'm having a problem which constructing an appropriate query for updating two tables simultaneously.

My tables are as such:

Tabel A

Table B

Table C

table A PK is an auto-increment field
table A has a 1:M relationship with table C
table B has a 1:M relationship with table C

The problem is as follows:

1. Table A and B are to be updated simultaneously.
2. While updating table B, the primary key from the update of table A is to be used as a foreign key.

So my question is; How do i run a query to insert a price for table A while using the pID generated to insert into table B. Below is an example of the queries which i think may be useful in further understanding what it is that i am trying to achieve.

INSERT INTO table B values (NULL, 'price');
INSERT INTO table C values ('pID' , 'AttID'); <-- the pID from this insert is to be obtained from the query above

Your help is MUCH appreciated.


Edited 2 time(s). Last edit at 04/11/2010 02:00AM by tyson crouch.

Options: ReplyQuote

Written By
Update query problems
April 11, 2010 01:43AM

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.