mysql根据一个表的字段更新另一个表的字段,如下所示:
update customer dw
set dw.careername =(select occname from occtable where occcode=dw.occcode)
where dw.occcode is not null and dw.career_name ="")
mysql根据一个表的字段更新另一个表的字段,如下所示:
update customer dw
set dw.careername =(select occname from occtable where occcode=dw.occcode)
where dw.occcode is not null and dw.career_name ="")