Trying to update woeid on geoplanet_adjacencies with matching replacement_woeid from a changes.tsv file in MySQL.

gistfile1.sql

CREATE TEMPORARY TABLE geoplanet_changes (
  woeid BIGINT(20) NOT NULL PRIMARY KEY,
  replacement_woeid BIGINT(20) NOT NULL,
  data_version VARCHAR
);

LOAD DATA INFILE 'infile.tsv' INTO TABLE geoplanet_changes
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"'
(woeid, replacement_woeid, data_version);

SHOW COLUMNS FROM geoplanet_adjacencies;

UPDATE geoplanet_adjacencies, geoplanet_changes
SET geoplanet_adjacencies.woeid = geoplanet_changes.replacement_woeid
WHERE geoplanet_adjacencies.woeid = geoplanet_changes.woeid;

DROP TEMPORARY TABLE geoplanet_changes;