Cacher is the code snippet organizer for pro developers

UPDATE oxarticles AS c

LEFT JOIN oxarticles AS p
  ON p.oxid = c.oxparentid

SET 
  c.oxweight = p.oxweight,
  c.oxlength = p.oxlength,
  c.oxheight = p.oxheight
	
WHERE p.oxid IN ('ad53fd0ac9d0598e48d0407ae1fa790c')