Truncated data LOAD DATA INFILE

Asked

Viewed 192 times

1

I have a problem with load data, trying to insert the CSV file the data is truncated because in fields like comments or 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 since this report I get comes from another company, I can’t change the way it’s generated. someone knows how I can delete commands \t and \r\n extras that should be the possible cause of the problem?

mysql
No answers

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.