我有两个表,并希望用另一个表的值更新其中一个表。
software
---------
id ,
purchprice
softwarecost
------------
id ,
purchprice
我尝试过这些查询,但是SQLite不支持UPDATE连接。
UPDATE software
SET software.purchprice=softwarecost.purchprice
WHERE software.id=softwarecost.id
UPDATE software
INNER JOIN softwarecost on software.id=softwarecost.id
SET software.purchprice=softwarecost.purchprice
发布于 2018-01-19 15:49:57
UPDATE
software
SET purchprice = (SELECT purchprice
FROM softwarecost
WHERE id = software.id)
where EXISTS (SELECT purchprice
FROM softwarecost
WHERE id = software.id)
在这里,我们使用EXISTS。如果没有找到“correlated”行,则software.purchprice
为空。
发布于 2018-01-19 17:09:28
您必须使用关联子查询查找相应的值:
UPDATE software
SET purchprice = (SELECT purchprice
FROM softwarecost
WHERE id = software.id)
https://stackoverflow.com/questions/-100003418
复制相似问题