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
