#关联更新语句
UPDATE customer_supplier as aa
inner join (SELECT cspg.product_id,cspg.product_name
FROM customer as cspg
WHERE cspg.product_name NOT LIKE '%...%'
GROUP BY cspg.product_id
ORDER BY cspg.product_name
) as bb on bb.product_id = aa.product_id
SET aa.product_name = bb.product_name
WHERE aa.product_name LIKE '%...%';
#改造成更新语句的查询语句
SELECT aa.*,bb.product_name FROM customer_supplier as aa
inner join (
SELECT cspg.product_id,cspg.product_name
FROM customer as cspg
WHERE cspg.product_name NOT LIKE '%...%'
GROUP BY cspg.product_id
ORDER BY cspg.product_name
) as bb on bb.product_id = aa.product_id
WHERE aa.product_name LIKE '%...%';