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?
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
