PostgreSQL 如何在表之间复制数据 [英] How do I copy data between tables PostgreSQL

问题描述

我有两个表:account_company 和 document_invoice.表 account_company 有 2 列:company_id 和 company_name.表 document_invoice 具有相同的列:company_id 和 company_name.发生了一些事情，从 document_invoice 中删除列公司名称的所有数据.

I have two tables: account_company and document_invoice. Table account_company has 2 columns: company_id and company_name. Table document_invoice has the same columns: company_id and company_name. Something happened and delete all data from column company name from document_invoice.

如何编写 SQL 查询将数据从客户公司表复制到 document_invoice?我一直在使用 UPDATE 和 SET，但我不知道具体如何.

How can I write SQL query to copy data from account company table to document_invoice? I have been using UPDATE and SET but I don't know exactly how.

UPDATE document_invoice
   SET company_name = (SELECT company_name FROM account_company)
 WHERE document_id.company_name=document_id.account

推荐答案

这应该可行:

UPDATE document_invoice t1 
SET company_name = t2.company_name
FROM account_company t2 
WHERE t1.company_id = t2.company_id

这篇关于PostgreSQL 如何在表之间复制数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！