Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
10 lines (8 sloc) 264 Bytes
LOAD DATA LOCAL INFILE 'LGCSB-gplan.csv'
INTO TABLE applications
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
UPDATE applications SET lat = NULL WHERE lat = 0;
UPDATE applications SET lng = NULL WHERE lng = 0;
Something went wrong with that request. Please try again.