如何在 PostgreSQL 中进行更新 + 加入? [英] How to do an update + join in 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 语法

The UPDATE syntax is:

a> 是:

在你的情况下，我认为你想要这个:

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屋！