如何将数据从一个表导入另一个表 [英] How to import data from one table into another

问题描述

我需要将数据从 Intel_Data表移动到 Intel_MainDataTable表中进入 sql Server。我有以下查询

  INSERT   INTO  Intel_MainDataTable 
  SELECT  * 
  FROM  Intel_Data 
  WHERE  Intel_MainDataTable.id！= Intel_Data.id 

但< span class =code-keyword>此代码会出错，它表示Intel_MainDataTable.id donn ' 存在。两个表都有相同的字段。它们完全相同。谁能帮我写出正确的查询？ 

解决方案

尝试选择进入。

 SELECT * 
 INTO Intel_MainDataTable 
 FROM Intel_Data Intel_MainDataTable; 

更多信息 - SQL SELECT INTO语句 [ ^ ]。

尝试：

 INSERT INTO newtable 
 SELECT * FROM oldtable 
 WHERE oldtable.id不在
（从newtable中选择id）

或

 INSERT INTO newtable 
 SELECT * FROM oldtable 
 WHERE NOT EXISTS 
（SELECT * from newtable where id = oldtable.id）; 

I need to move data from Intel_Data table into Intel_MainDataTable table into sql Server. I have following query

INSERT INTO Intel_MainDataTable 
    SELECT * 
    FROM Intel_Data
    WHERE Intel_MainDataTable.id != Intel_Data.id

But this code gives errors, it says that Intel_MainDataTable.id donn't exists. Both Tables have same fields. They are identical. Who can help me to write correct this query ?

解决方案

Try select into.

SELECT *
 INTO Intel_MainDataTable
 FROM Intel_Data Intel_MainDataTable;

Some more info - SQL SELECT INTO Statement[^].

Try:

INSERT INTO newtable
SELECT * FROM oldtable
WHERE oldtable.id not in
(select id from newtable)

Or

INSERT INTO newtable
SELECT * FROM oldtable
WHERE NOT EXISTS
(SELECT * from newtable where id=oldtable.id);

这篇关于如何将数据从一个表导入另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！