UPDATE 表a as a,表b as b
SET a.long_lat = CONCAT(b.longitude,’,’,b.latitude)
WHERE a.id = b.id
合并列后关联更新
最新推荐文章于 2021-12-16 10:03:51 发布
UPDATE 表a as a,表b as b
SET a.long_lat = CONCAT(b.longitude,’,’,b.latitude)
WHERE a.id = b.id