Greetings.. The MySQL Documents will be a nice place.
Maybe this will help if you want to copy all the data as well as columns from the - create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table (this will create the table with the existing datas ) to do only structure copy ( i.e without any data ) use the following SQL create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table where 1=0 Hope it helps. Insane SQLyog - The Definative Win32 GUI For MySQL http://www.webyog.com/sqlyog ----- Original Message ----- From: "Tim Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 12, 2002 10:33 PM Subject: Storing results from a Query in an existing Table > 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 > --------------------------------------------------------------------- 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
