Copying data from one table to another with MYSQL and PHP

[fluiduk]

Hi All

I need a query that will duplicate all of the values of one table into another.

Basically I am trying to create a master table, that contains all of the contents of six other tables.

I want to know if there is a simply mysql query that will do this, as oppose to having to read all the data out of one table and write it back into another.

Thanks
Aaron

 

[fluiduk]

In the end I managed to find this query.

"INSERT INTO master_list SELECT * FROM mw_temp"

I usually use Mysql Front for managing dbs etc, however this is part of a php app so needed to do it via PHP

Thanks
Aaron