如何在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