Remove the "values" in your sql and see
--
On Fri, 23 Mar 2001 13:00:23
Boget, Chris wrote:
>> 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
>
Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
