List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 12 2002 5:47pm
Subject:Re: Storing results from a Query in an existing Table
View as plain text  
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 other tables and
>"append" them to Wines.
>
>   I have tried the following:
>     LOAD DATA SELECT Country,Varietal,Producer,Vineyard,Year,Size 
>FROM EUR INTO TABLE Wines;
>
>   and MySQL finds me lacking in imagination ... :-(
>
>How may I accomplish this?
>And where is documentation on this topic?

In the manual: http://www.mysql.com/doc/en/INSERT_SELECT.html


>TIA
>--
>Tim Johnson <tim@stripped>
>       http://www.alaska-internet-solutions.com
>       http://www.johnsons-web.com

Thread
Storing results from a Query in an existing TableTim Johnson12 Oct
  • Re: Storing results from a Query in an existing TablePaul DuBois12 Oct
  • Re: Storing results from a Query in an existing TableInsanely Great12 Oct