mysql update 多表关联更新 

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'

 

posted @ 2019-05-17 19:01  AngDH  阅读(2109)  评论(0)  编辑  收藏  举报