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