关联修改表数据
update `records` r,`collect_point_info` p
set r.`point_desc` = p.`desc`,r.`siteno` = p.`siteno`,r.`termno` = p.`termno`
where r.point_id = p.id and point_desc = '';
关联修改表数据
update `records` r,`collect_point_info` p
set r.`point_desc` = p.`desc`,r.`siteno` = p.`siteno`,r.`termno` = p.`termno`
where r.point_id = p.id and point_desc = '';