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 ot
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 exist