How to load a text file into a table column using mysql

Hi
I am trying to import simple text files into a table, one column at a time.
I have imported the first one using:

insert into tpins(part_number)   select  * from temptpins1;

Code (markup):

which it did do fine.

Now I wish to import a second file into the second column of same table. stating from row one again.
I have found that I may have to use "load data " command, such as :

load data infile 'temptpins0d' into table tpins (Ød);

Code (markup):

but it gives me this error "Access denied for user 'XXX'(using password yes).

The text file is also a table with one column, in the server.
How can I copy this column of data into tpins's second column table starting from row1 (i.e no insert)
Thx in advance

 

Hi
I thought I make the problem a little clearer.
What I am really trying to do is copy the first row of column a from table a into first row of table b in column b. repeat until all data copied.
the only thing that needs bearing in mind is that there are already data in column a of table b.

Hope this has made it clearer.
thx

 

Anyone knows what is the way to get a email to mysql database without anyone user interaction
Subject, sender email is there in a table and without opening email (lets say gmail) i should be able to get those data to my mysql table

 

are you sure your connecting to the right place with the correct username and pass ?

i.e localhost, username, password ?

Double check these are correct ?