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

[darion mapp]

NO it is not possible to use subselects at this point BUT It is possible to insert via 
a select check the mysql site for the insert syntax
--

On Fri, 23 Mar 2001 12:41:04  
 Boget, Chris wrote:
>> 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
>


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]