Re: Copy data from one table to another. How to? Subselects not supported as far as I know.
| From: | Jason Wong | Date: | Wed, 10 Apr 2002 14:29:13 +0000 |
| Subject: | Re: Copy data from one table to another. How to? Subselects not supported as far as I know. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18386@lists.php.net to get a copy of this message | ||
On Wednesday 10 April 2002 18:54, andy wrote:
> Hi there,
>
> I have a table containing data already. Now there is another table with
> data I would like to add to the other one.
> As far as I know mysql does not support subselects. So how could I add this
> data to the old table?
Use "INSERT ... SELECT", refer to manual for details.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Welcome to the Zoo!
*/