LOAD DATA INFILE语句导入数据进入MySQL的一些注意事项

可以用以下语句导入CSV或其他格式数据进入MySQL数据库，

LOAD DATA LOCAL INFILE "C:\wamp\apps\litigationinfo.csv" 
REPLACE INTO TABLE litigationinfo 
CHARACTER SET utf8
FIELDS TERMINATED BY "," 
ENCLOSED BY "" 
LINES TERMINATED BY "\r\n"
IGNORE 1 LINESLOAD DATA LOCA