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