mysql

更新操作关联表：

UPDATE tnt_biz_product_price_print pp
INNER JOIN tnt_biz_product_info pi ON pp.product_uid = pi.product_uid
SET pp.updated_by = '123',
pp.updated_at = NOW(),
pp.print_date = NOW(),
pp.print_status = 'TYP_PRINTED'
WHERE pp.archive = 1
AND pi.price_tag_review_status = 'TYP_APPROVED'
AND pp.apply_record_uid = 43359185240686609