[plug] mysql query questoin

[Anne Busby]

Try

INSERT INTO <table2> SELECT <fields> FROM <table>;

Anne

On Sun, 2003-01-19 at 20:52, Jon Miller wrote:
> I'm trying to do a query in mysql whose results I want to put in another
> mysql database/table.
> The query part I have that correct as the results are right, from there
> I'm lost.  Does anyone know who this is suppose to work?
> is it the SELECT .... INSERT syntax?
> 
> Thanks
> -- 
> Jon Miller <jlmiller at mmtnetworks.com.au>
> MMT Networks Pty Ltd
> 
> 
> 
-- 
Regards,
Anne Busby
E-Mail: mailto:anne at busby.net
Web: http://www.busby.net