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