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