LOAD DATA LOCAL INFILE '../datafiles/payments.txt' INTO TABLE Payments FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';