| id | woeId | lft |
|---|---|---|
| 1 | 3894384 | XXX |
| 2 | 3894385 | XXX |
| 3 | 3894386 | XXX |
woeId | name | lft -----------| ---- | ---- | --------- 3894384 | A | 23 3894385 | B | 45 3894386 | C | 57
Created
July 5, 2014 15:35
-
-
Save Kalyse/f06be10b66a43cff8224 to your computer and use it in GitHub Desktop.
Query for Updating Entities to Match their Geo Places lft values.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
update entities e inner join geo_places p on e.woeid = p.woeid set e.lft = p.lft