UPDATE new_schedules_spider_static_schedule s join new_scac_port p on p.`PORT` = s.`PORT` and p.SCAC = ‘aaa‘ set s.PORT_CODE = p.BASIC_CODE WHERE s.SCAC = ‘aaa‘
mysql update 多表关联更新
原文：https://www.cnblogs.com/angdh/p/10883136.html
