[plug] mysql query questoin

[Jon Miller]

Would table2 be in the form of <database2.table2> because the results
from <table1> is to go into a separate database and it's tables).


Thanks


On Sun, 2003-01-19 at 21:09, Anne Busby wrote:
> 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
> > 
> > 
> > 
-- 
Jon Miller <jlmiller at mmtnetworks.com.au>
MMT Networks Pty Ltd