Skip to content

Instantly share code, notes, and snippets.

@mrpunkin
Created April 6, 2015 23:36
Show Gist options
  • Save mrpunkin/1003bd06d54a4e4ce741 to your computer and use it in GitHub Desktop.
Save mrpunkin/1003bd06d54a4e4ce741 to your computer and use it in GitHub Desktop.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOAD DATA INFILE '/Users/Bryan/Sites/rubyapps/pc_3.0/db/data/geoplanet_data_7.5.' at line 7:
CREATE TEMPORARY TABLE geoplanet_changes (
woeid BIGINT(20) NOT NULL PRIMARY KEY,
replacement_woeid BIGINT(20) NOT NULL,
data_version VARCHAR(255)
);
LOAD DATA INFILE '/Users/Bryan/Sites/rubyapps/pc_3.0/db/data/geoplanet_data_7.5.1/geoplanet_changes_7.5.1.tsv' INTO TABLE geoplanet_changes
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
(woeid, replacement_woeid, data_version);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment