MySql import with crlf
If your text file lines end with carriage return / line feed, you will need \r in addition to \n to have clean data import:
LOAD DATA LOCAL INFILE 'c:\\www\\package.txt'
INTO TABLE businesscategory
LINES TERMINATED BY '\r\n'
(businesscategory);
Trackback URI |