LOAD DATA LOCAL INFILE 'c:\\file.csv' INTO TABLE tablename FIELDS TERMINATED BY '' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';