本文已参与「新人创作礼」活动，一起开启掘金创作之路。
UPDATE `db_smart_common`.`sys_project_info` spi,
`db_sensor`.`dust_project_info` dpi
SET
spi.enterprise_project_manager = dpi.sgdwxmjl,
spi.enterprise_project_manager_phone = dpi.sgdwxmjldh,
spi.enterprise_safe_leader = dpi.qyaqfgld,
spi.enterprise_safe_leader_phone = dpi.qyaqfglddh,
spi.supervision_department = dpi.jldw,
spi.project_director = dpi.xmzj,
spi.project_director_phone = dpi.zjlxdh,
spi.is_apply_culture = dpi.sfsbwmgd,
spi.is_belong_government = dpi.sfzfxm,
spi.is_apply_highquality = dpi.sfsbyzgc,
spi.arrears_reimburse_agreement = dpi.qxqcxyfj,
spi.construction_content = dpi.jsnr,
spi.project_status = dpi.project_status,
spi.environmental_principal = dpi.hbfzr,
spi.environmental_principal_phone = dpi.hbfzr_phone
WHERE
spi.project_id = dpi.project_id
