UPDATE tp_order_goods a INNER JOIN tp_goods b ON a.goods_id = b.goods_id set a.goods_remark=b.goods_remark;