Re: Storing results from a Query in an existing Table

2002-10-13 Thread Paul DuBois
At 9:03 -0800 10/12/02, Tim Johnson wrote: >Hello All: > I have learned to extract columns from one table and >create a new table from those columns->i.e: > >CREATE TABLE Wines SELECT >Country,Varietal,Producer,Vineyard,Year,Size FROM AH; > >Now I would like to SELECT the same columns from ot

Re: Storing results from a Query in an existing Table

2002-10-13 Thread Insanely Great
Greetings.. The MySQL Documents will be a nice place. Maybe this will help if you want to copy all the data as well as columns from the - create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table (this will create the table with the exist