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!
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to