UPDATE boom_talent_channel tc
INNERJOIN(SELECT talent_id,dict_category_key,dict_category_value from boom_talent) t ON tc.talent_id = t.talent_id
SET tc.dict_category_key=t.dict_category_key,tc.dict_category_value=t.dict_category_value
mysql 批量更新(先查询再更新) UPDATE boom_talent_channel tcINNER JOIN(SELECT talent_id,dict_category_key,dict_category_value from boom_talent) t ON tc.talent_id = t.talent_idSET tc.dict_category_key=t.dict_category_key,tc.dict_category_value=t.dict_category_value