Select then Insert into another table

[CBG]

Hi,

 

I would like to do the following in PHP using a MySQL database, but not sure how.

 

select a, b,c etc.. from mailbox where id = X

then

insert id,a,b,c etc.. into problem

 

When I select, I will be calling the id

 

So I would like it to get data from mailbox and then insert it into problem.

How would I go about doing this?

 

Thanks for any help you can give me

[Lyleyboy]

Try having a read about subqueries or derived tables as they are sometimes know.

 

Something like this should work

INSERT INTO tblTABLE SET (Field1, Field2)
VALUES (SELECT Field1, Field2 FROM tblTABLE2)

 

It's a very simplified example but the logic should work.

[CBG]

Thanks for the reply

I will give that code ago and if it doesn't work do a google on subqueries and/or derived tables.

 

Thanks again

[CBG]

Just thought I would come back with a follow up on this.

It working fine. I didn't put SET in it, as I thought that was for update.

 

But anyway it works great.

Thank you very much