Sam's notebook

Loading spatial data into MySQL with LOAD DATA INFILE July 23rd, 2015, 9AM

Programming

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) ;

[No comments] [Keywords: , , , , , , , , ] [Permanent link]