David Romaní davidromani

bytes' tamer since 1984

davidromani / CSV to MySQL

Created May 8, 2012 06:12

Import CSV into MySQL table

	LOAD DATA LOCAL INFILE '/path/to/file.csv' INTO TABLE <database.table_name>
	FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
	(field1, field2, fieldN);