如何在PostgreSQL中进行更新+加入? [英] How to do an update + join in PostgreSQL?
本文介绍了如何在PostgreSQL中进行更新+加入?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
基本上,我想这样做:
update vehicles_vehicle v
join shipments_shipment s on v.shipment_id=s.id
set v.price=s.price_per_vehicle;
我很确定这可以在MySQL(我的背景)中使用,但似乎在postgres中不起作用.我得到的错误是:
I'm pretty sure that would work in MySQL (my background), but it doesn't seem to work in postgres. The error I get is:
ERROR: syntax error at or near "join"
LINE 1: update vehicles_vehicle v join shipments_shipment s on v.shi...
^
当然有一种简单的方法可以做到这一点,但是我找不到合适的语法.那么,我将如何在PostgreSQL中编写此代码?
Surely there's an easy way to do this, but I can't find the proper syntax. So, how would I write this In PostgreSQL?
推荐答案
UPDATE语法是:
[ WITH [ RECURSIVE ] with_query [, ...] ]
UPDATE [ ONLY ] table [ [ AS ] alias ]
SET { column = { expression | DEFAULT } |
( column [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]
[ FROM from_list ]
[ WHERE condition | WHERE CURRENT OF cursor_name ]
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
在您的情况下,我认为您想要这样做:
In your case I think you want this:
UPDATE vehicles_vehicle AS v
SET price = s.price_per_vehicle
FROM shipments_shipment AS s
WHERE v.shipment_id = s.id
这篇关于如何在PostgreSQL中进行更新+加入?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文