把med_info4表中凡是属于同一个“成份名”的'通用名'的id_health字段更新为所属“成份名”的id_health
update med_info4 set id_health = b.id_health from med_info4 b, med_info4
where med_info4.mark_tym = '通用名'and med_info4.ID_TYM = b.id_Goods and b.mark_tym = '成份名'
把med_info4表中凡是属于同一个“成份名”的'通用名'的id_health字段更新为所属“成份名”的id_health
update med_info4 set id_health = b.id_health from med_info4 b, med_info4
where med_info4.mark_tym = '通用名'