zlargon · May 12, 2019 16:11
diff --git a/import_csv.sql b/import_csv.sql
 SET GLOBAL local_infile = true;
 SHOW GLOBAL VARIABLES LIKE 'local_infile';

 LOAD DATA LOCAL INFILE '<file.csv>'
 INTO TABLE '<table_name>'
 COLUMNS TERMINATED BY ','
 OPTIONALLY ENCLOSED BY '"'
 ESCAPED BY '"'
 LINES TERMINATED BY '\r\n'
 IGNORE 1 LINES;             -- ignore the field names
	SET GLOBAL local_infile = true;
	SHOW GLOBAL VARIABLES LIKE 'local_infile';

	LOAD DATA LOCAL INFILE '<file.csv>'
	INTO TABLE '<table_name>'
	COLUMNS TERMINATED BY ','
	OPTIONALLY ENCLOSED BY '"'
	ESCAPED BY '"'
	LINES TERMINATED BY '\r\n'
	IGNORE 1 LINES; -- ignore the field names