Skip to content

Instantly share code, notes, and snippets.

@bellerbrock

bellerbrock/merge locations sql

Created February 10, 2022 17:50
Show Gist options
  • Save bellerbrock/ed1293cc3e3ceaa0fd5043e6375622bf to your computer and use it in GitHub Desktop.
Save bellerbrock/ed1293cc3e3ceaa0fd5043e6375622bf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
merge locations sql
BEGIN;
UPDATE nd_experiment
SET nd_geolocation_id = 119
WHERE nd_geolocation_id = 52;
UPDATE projectprop
SET value = '119'
WHERE value = '52'
AND type_id = (
SELECT cvterm_id
FROM cvterm
WHERE name = 'project location'
);
COMMIT:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment