RE: [PHP] Move data from one MySql table to another?

[Boget, Chris]

> To populate new_table from old_table you can give it this SQL:
> INSERT INTO new_table (name, address) VALUES SELECT name, address FROM
> old_table;

Umm, I didn't think you could do subselects in MySQL?
Or am I missing something?

Chris