LOAD DATA mysql command and use only one column I have table t1 with three columns, and a file per line a text.
my tables contains id,sura and aya fields. I need to fill only aya from File. 
I use the following command:
load data infile '/home/mohsen/codes/haq/translation-tmp/fa.ghomshei.txt' into table tr_fa_ghomshei LINES TERMINATED BY '\n' ;

Now question is : 
How can I limit to aya field?
You can do :
load data infile '/home/mohsen/codes/haq/translation-tmp/fa.ghomshei.txt' into table tr_fa_ghomshei LINES TERMINATED BY '\n' (aya);