Skip to content

Instantly share code, notes, and snippets.

@hexfusion

hexfusion/gist:7724203

Created November 30, 2013 20:42
Show Gist options
  • Save hexfusion/7724203 to your computer and use it in GitHub Desktop.
Save hexfusion/7724203 to your computer and use it in GitHub Desktop.
Download ZIP
stage variants and make sure that existing items keep proper information
Raw
gistfile1.txt
UPDATE variants_staging as VS
JOIN variants AS V
ON VS.manf_sku = V.manf_sku
set VS.image = V.image, VS.style = 'Image', VS.code = V.code, VS.sku = V.sku
WHERE V.manf_sku = VS.manf_sku
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment