在SQLite中合并两个表 [英] Combine two tables in SQLite

问题描述

我有两个表ta和tb:

I have two tables, ta and tb:

ta:

key col1  
--------
k1 a 
k2 c 

tb:

key col2  
-------
k2 cc 
k3 ee 

它们通过键"连接.我想知道如何获得一个表tc，例如:

They connected by "key". I want to know how can I get a table, tc, like:

key col1 col2  
-------------
k1 a  
k2 c cc 
k3  ee

是否有一种简单的方法而不是插入每条记录?它们是一百万张表的记录，因此我需要一种有效的方法.

Is there a easy method instead of inserting every record? They are one million records of tables so I need an effective way.

推荐答案

制作 VIEW 这两个表.编写SELECT ... JOIN语句，为您提供所需的结果，然后将其用作VIEW的基础.

Make a VIEW of the two tables. Write a SELECT ... JOIN statement that gives you the result you want, and then use that as the base for a VIEW.

示例:

CREATE VIEW
  database.viewname
AS
  SELECT
    ta.key, 
    ta.col1,
    tb.col2
  FROM
    ta
   LEFT JOIN
    tb
   USING(key)

这篇关于在SQLite中合并两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！