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]
- RE: [PHP] Move data from one MySql table to another? James Atkinson
- Re: [PHP] mail(): carriage return required?? CC Zona
- RE: [PHP] mail(): carriage return required?? Eelco de Vries
- Re: [PHP] mail(): carriage return required?? Christian Reiniger
- Re: [PHP] Move data from one MySql table to another? darion mapp
- RE: [PHP] Move data from one MySql table to another? Boget, Chris
- RE: [PHP] Move data from one MySql table to another? Altunergil, Oktay
- RE: [PHP] Move data from one MySql table to another? darion mapp
- RE: [PHP] Move data from one MySql table to another? darion mapp
- RE: [PHP] Move data from one MySql table to another? Boget, Chris
- RE: [PHP] Move data from one MySql table to another? darion mapp
- RE: [PHP] Move data from one MySql table to another? Boget, Chris