Loading spatial data into MySQL with LOAD DATA INFILE

2015 July 23 (Thursday), 5:48PM

Just a note for my future reference: importing an Excel CSV into MySQL. The WKT column has been constructed by hand to be POINT(lng lat) and the CSV contains headers.

LOAD DATA INFILE '/full\_path/to/file-on-server.csv'
REPLACE INTO TABLE the\_table COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' IGNORE 1 ROWS (name,description,@geographic\_location)
SET geographic\_location = GeomFromText(@geographic_location);