mysql 联合更新

2016-08-16

 

UPDATE loreal.social_scan_top10_v2 a,
 loreal.social_scan_top10_base b
SET a.download_url = b.download_url
WHERE
    a.sys_date = b.sys_date
AND a.watch_url = b.watch_url;

 

UPDATE all_stat.Picture_RawData_IndkeyCount a,
 picture.indkey b
SET a.industry_id = b.id
WHERE
    a.keyword = b.keyword;