Skip to content

Instantly share code, notes, and snippets.

@jsstoni

jsstoni/actualizar.sql

Created January 21, 2020 17:08
Show Gist options
  • Save jsstoni/4aa857ad0d808660e516fb1f3b9f9662 to your computer and use it in GitHub Desktop.
Save jsstoni/4aa857ad0d808660e516fb1f3b9f9662 to your computer and use it in GitHub Desktop.
Download ZIP
actualizar bak
Raw
actualizar.sql
UPDATE `productos` JOIN `bak_tallas` on `productos`.`sku` = `bak_tallas`.`sku` SET `productos`.`a`=`bak_tallas`.`a`, `productos`.`b`=`bak_tallas`.`b`, `productos`.`c`=`bak_tallas`.`c`, `productos`.`d`=`bak_tallas`.`d`, `productos`.`e`=`bak_tallas`.`e`, `productos`.`f`=`bak_tallas`.`f`, `productos`.`g`=`bak_tallas`.`g`, `productos`.`h`=`bak_tallas`.`h`, `productos`.`i`=`bak_tallas`.`i`, `productos`.`j`=`bak_tallas`.`j` WHERE `productos`.`sku`=`bak_tallas`.`sku`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment