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

[Boget, Chris]

> MySQL only supports INSERT ... SELECT ... and REPLACE ... SELECT ...
> Independent sub-selects will probably be available in Version 
> 4.0. You can now use the function IN() in other contexts, however. 

I tried the query in the original post and I could not get it to work.
This is what I got:

mysql> insert into new_names (name, email) values select name, email from 
old_names;
ERROR 1064: You have an error in your SQL syntax near 'select name, email 
from old_names' at line 1

What's going wrong if this is supposed to work?
I'm using mySQL 3.22.32

Chris