load data infile to mysql

[Deviji]

Hi
i want to read data from text file which is on ftp server & store it in MySQL DB.
For ex mytextfile contains

data1 data2 data3
data4 data5 data6

all data are tab seprated.i have written below query to read textfile & load it in mysql DB.but it is not aading first fields of each row into database.but as soon as i gave tab on first field also then it is working fine.i m not getting where i m wrong please help.
thnks in adv.

load data infile 'mytextfile.txt' into table mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'

[NogDog]

I'm guessing that that first column in the table is an auto-increment key field that is not included in the text file? If so, you may need to add a column list for the names of the columns that correspond to the fields in the text:

LOAD DATA INFILE 'mytextfile.txt' INTO TABLE mytable 
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
(column_name_1, column_name_2, column_name_3)

[Deviji]

Yes the problem is resolved by adding column names.
Thanks Charles