一、update
UPDATE tableA a,tableB b
set a.corporation_id = b.company_id,
a.corporation_name = b.company_name,
a.brand_id = b.brand_id,
a.brand_name = b.brand_name,
a.series_id = b.series_id,
a.series_name = b.series_name
where a.series_name like concat("%",b.series_name,"%"); -- 模糊匹配
二、update join
where后要加关联的字段
update tableA a join tableB b
set a.corporation_id_new = b.company_id ,
a.corporation_name_new = b.company_name
where a.corporation_name = concat(b.company_name,"汽车") and a.corporation_name_new is null ;