mysql --local-infile=1 -u USERNAME -p DATABASE
LOAD DATA local INFILE '/home/username/file.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (a,b,c);
mysql --local-infile=1 -u USERNAME -p DATABASE
LOAD DATA local INFILE '/home/username/file.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (a,b,c);