Please help importing columns

[lingo5]

Hi,

I would like to import several columns of a table from database A to database B.

Database A has more columns than database B,but they have several columns with the eact same name.

I have exported the table from database A as a CSV file.

I have tried to import the CSV file to database B, but it imports all the tables and inserts the contents of the non existing tables in db B in the wrong columns.

 

My question is: can I select the columns I want to import from db A and insert their contents in the colums of db B I want?

 

Hope I make sense...thanks.

[fenway]

I have tried to import the CSV file to database B, but it imports all the tables and inserts the contents of the non existing tables in db B in the wrong columns.

"it imports"? What's "it"?

[lingo5]

sorry I mean when I import the CSV I don't know how to select only the columns i want ...so I end up importing data from db A into the wrong columns of db B...

[fenway]

LOAD DATA INFILE let you specify columns.

[lingo5]

Thanks fenway..could you please provide an easy to understand for newbie example?

Many many thanks

[The Little Guy]

if the databases are on the same server and the same user has access to them, you could do this:

 

create table DatabaseB.TableA select * from DatabaseA.TableA

[lingo5]

Thanks little guy, but that creates a cop of the table from db A on db B....right?

I need to be able to import just some columns from A to B.

[The Little Guy]

then list the columns you want in the select like this:

 

create table DatabaseB.TableA select col1, col3, col4, col10 from DatabaseA.TableA

[lingo5]

OK, thanks ..I will try this tomorrow because I'm in Spain and it's quite late...gotta go to bed !!!