![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
东皇
人生就是一场修行,天赋决定起点,努力决定终点。
展开
-
合并列后关联更新
UPDATE 表a as a,表b as bSET a.long_lat = CONCAT(b.longitude,’,’,b.latitude)WHERE a.id = b.id原创 2020-08-27 17:55:35 · 112 阅读 · 0 评论 -
两表关联更新某个字段
UPDATE 表A as a,表B as b SET a.labour_company_id = b.id WHERE a.remark = b.remark原创 2020-08-19 16:37:17 · 1899 阅读 · 0 评论 -
sql关联更新
UPDATE base_build_le_shan AS aINNER JOIN (SELECTSERIAL_NO,IDFROMbase_land_le_shan) AS b ON a.SERIAL_NO = b.SERIAL_NOSET a.LAND_ID = b.ID转载 2019-06-17 15:50:22 · 315 阅读 · 0 评论