taking a value from one table into another

[ratso]

Hello,

I am trying to take a value from one table and insert it into another, is there any way I can do this solely in mysql instead of using php?

I have searched about but can find no answer.

Thanks

[xblue]

is this what you are looking for?
http://www.mysql.com/doc/en/INSERT_SELECT.html

[superwormy]

INSERT INTO tablename SELECT * FROM table2

[ratso]

Thanks chaps!!

That worked a treat, I just obviously wasn't asking the question in the right way with the mysql documentation, but my wording was understood here.

Sorry took so long to reply, posted the question before I went to work this morning.

thanks again!