1:根据一个表某字段更新另外一个表中的字段
update in_investorinfo set in_investorinfo.province=(select in_citybaseinfo.cityName from in_citybaseinfo where in_citybaseinfo.cityName=in_investorinfo.investorSource)
2:通过一个表更新另外一个表。采用子查询的方式
update sr_fund s set steadycode = (select steadycode from sr_teacherinfo where sr_teacherinfo.`name` = s.chargeName)