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

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