I have a problem with load data, trying to insert the CSV file the data is truncated because in fields like comments or in the address.
LOAD DATA INFILE 'exemplo.csv'
INTO TABLE relat_produt_analistas_temp
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
This is the query I'm using.
And as this report I get comes from another company, I can not change the way it is generated.
does anyone know how I can delete commands
\t
and \r\n
extras that should be the possible cause of the problem?