This is an Error that I made many times and cannot remember how to fix it, which in turn cost a lot of googling time.
The problem laid in the difference between Unix an Windows ....... Dont use "\r" when you are on windows Machine
LOAD DATA LOCAL INFILE 'd:/www/text.csv' INTO TABLE table
FIELDS TERMINATED BY ','
LINES TERMINATED BY "\n"
IGNORE 1 LINES
The problem laid in the difference between Unix an Windows ....... Dont use "\r" when you are on windows Machine
LOAD DATA LOCAL INFILE 'd:/www/text.csv' INTO TABLE table
FIELDS TERMINATED BY ','
LINES TERMINATED BY "\n"
IGNORE 1 LINES
No comments:
Post a Comment