O red that the correct syntax for importing .text is
Load data local infile 'path' to table x
If the arrangement /position of the columns in the .txt file are different from the actual table but they have the same definitions i should write like this
Load data local infile 'path' to table x(column1,column2..)
I did it and it doesn t work , also tried to put the columns last after the fileds,enclosured ,lines etc. What am i doing wrong?