三个表的复杂更新 [英] complex update on three tables
问题描述
我有3张桌子像
表A //用户
援助(pk)内容已锁定
表B //文章
出价(pk)援助(fk)内容已锁定
表C //评论
Cid(pk)出价(fk)内容已锁定
i想要将列锁定值更新为1
其中Aid = xx(tableA)
表B中的
所有Aid列的匹配值为xx,然后锁定值为1 <表格中的
所有具有受影响的tableB的Bid列然后锁定值为1
pk--主键
fk--外键
提前感谢
i have 3 tables like
table A//user
Aid(pk) content locked
table B//article
Bid(pk) Aid(fk) content locked
table C//comment
Cid(pk) Bid(fk) content locked
i want to update the column locked value as 1
where Aid=xx (tableA)
in tableB
all Aid column with matching value xx then locked value as 1
in tableC
all Bid column with affected tableB then locked value as 1
pk-- primary key
fk-- foreign key
thanks in advance
推荐答案
我想将列锁定值更新为1
其中Aid = xx (tableA)
i want to update the column locked value as 1
where Aid=xx (tableA)
UPDATE tableA
SET locked = 1
WHERE Aid = [some value]
在表B中
所有Aid列的匹配值为xx,然后锁定值为1
in tableB
all Aid column with matching value xx then locked value as 1
UPDATE tableb, tablea
SET tableb.Locked = 1
WHERE tablea.Aid = tableb.Aid and tablea.Aid = [some value]
在表C中
所有具有受影响的tableB的Bid列然后锁定值为1
in tableC
all Bid column with affected tableB then locked value as 1
UPDATE tableb, tablea,tablec
SET tablec.Locked = 1
WHERE tablea.Aid = tableb.Aid
and tableb.Bid = tablec.Bid
and tablea.Aid = [some value]
您还可以看看在以下链接
掌握SQL UPDATE语句 [ ^ ]
SQL Server中的UPDATE基础知识 [ ^ ]
希望这有帮助。
You can also take a look at the below links
Mastering the SQL UPDATE Statement[^]
UPDATE Basics in SQL Server[^]
Hope this helps.
这篇关于三个表的复杂更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!