Losing the last column of data After Loading data into the table and running  a query on it, it tends to lose the last column of it. Like somewhere in import process it lost it. The file i was using was UTF-8 .csv format. A
Is there anything i need to add to this :

LOAD DATA LOCAL INFILE 'xxx/xxxx/Desktop/xxx/xxxx/file.csv'
INTO TABLE opendns_cc
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;


/Names in the path are changed due to security/
you could add an empty field at the end of each line, and remove the last column of your table.

Otherwise check for all the line terminations (\r\n vs. \n), or the presence of \n in your contents...

It should work at the end, good luck !