SQL Update更新表数据关联表
sql表字段更新
SQL两张表关联更新,从B表更新A表value字段,A表和B表通过ID关联
第一种写法 (推荐)
SQL 全选
update table_a set value = b.value from table_a as a inner join table_b as b on a.id = t1.id
第二种写法
SQL 全选
update table_a set value = b.value from table_b as b where table_a.id = b.isid
MySQL关联更新语句
SQL 全选
UPDATE unit u
JOIN unit_fix uf ON u.unit_id = uf.unit_id
SET u.price = uf.price,
u.fix_flag = 1
WHERE
uf.tender_id IS NOT NULL;
参考:https://blog.csdn.net/moshowgame/article/details/109809642
版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
post 张国生