krot

UPDATE SELECT

Oct 15th, 2017
90
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE `s_product` AS pp, `s_price` AS p
  2. SET pp.udate = p.udate,pp.pdate = p.udate
  3. WHERE pp.idPrice = p.ID
  4. UPDATE `s_product` p,`op_product` pp
  5. SET pp.udate = pp.udate,pp.pdate = p.pdate
  6. WHERE p.idPrice=87 and p.ID=pp.idProd and p.hash=pp.hash
  7. UPDATE `s_product` p
  8. JOIN `op_product` pp on  p.hash=pp.hash
  9. JOIN `o_offer` of on of.ID=pp.idOffer
  10. JOIN `s_route` r on r.ID=of.idRoute
  11. SET pp.udate = pp.udate,pp.pdate = p.pdate
  12. WHERE p.idPrice=87 and r.idCity=1
RAW Paste Data