At 9:03 -0800 10/12/02, Tim Johnson wrote:
> 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
>Tim Johnson <tim@stripped>