Skip to content

Instantly share code, notes, and snippets.

@jatorre
Last active December 23, 2015 10:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jatorre/6622239 to your computer and use it in GitHub Desktop.
Save jatorre/6622239 to your computer and use it in GitHub Desktop.
Small update example optimized
UPDATE wahlen_by_2013_test o
SET averagevalue=n.averagevalue,
constituencyname=n.constituencyname,
electionwinnerpartyname1=n.electionwinnerpartyname1,
electionwinnerpartyname2=n.electionwinnerpartyname2,
electionwinnerpartypercent1=n.electionwinnerpartypercent1,
electionwinnerpartyperson1=n.electionwinnerpartyperson1,
freie_waehler_percent2=n.freie_waehler_percent2,
gruene_percent2=n.gruene_percent2,
piraten_percent2=n.piraten_percent2,
sonstige_percent2=n.sonstige_percent2,
spd_percent2=n.spd_percent2,
turnoutofvoters=n.turnoutofvoters
FROM ( VALUES
(2.31,'Nürnberger Land','csu','csu',41.33,'Dünkel Norbert',10.73,9.24,1.85,10.22,24.44,68.7,511),
(2.31,'Nürnberger Land','csu','csu',41.33,'Dünkel Norbert',10.73,9.24,1.85,10.22,24.44,68.7,511)
-- .... ONE LINE PER LAND! ....--
) n(
averagevalue,
constituencyname,
electionwinnerpartyname1,
electionwinnerpartyname2,
electionwinnerpartypercent1,
electionwinnerpartyperson1,
freie_waehler_percent2,
gruene_percent2,
piraten_percent2,
sonstige_percent2,
spd_percent2,
turnoutofvoters,
constituencynr)
WHERE o.constituencynr = n.constituencynr;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment