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 <[EMAIL PROTECTED]> > http://www.alaska-internet-solutions.com > http://www.johnsons-web.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
