RE: [PHP] Move data from one MySql table to another?
| From: | darion mapp | Date: | Fri, 23 Mar 2001 18:45:58 +0000 |
| Subject: | RE: [PHP] Move data from one MySql table to another? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-45323@lists.php.net to get a copy of this message | ||
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