本文介绍了如何在 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 中进行更新 + 加入?
发布评论