现在有两张表chargedevice 和chargedeviceTest两张表 其中chargedevice表中是有数据的chargedeiceTest表中没有数据:
1. INSERT INTO 目标表 SELECT * FROM 来源表;
从chargedevice导入全部数据到chargedeviceTest表中
INSERT INTO CHARGEDEVICETEST SELECT * FROM CHERGEDEVICE
2, INSERT INTO 目标表 (字段1, 字段2, ...) SELECT 字段1, 字段2, ... FROM 来源表;
从chargedevice导入部分字段的数据到chargedeviceTest表中
INSERT INTO CHARGEDEVICETEST (NAME,PILEINDEX)SELECT NAME,PILEINDEX FROM CHARGEDEVICE
3.如果您需要只导入目标表中不存在的记录,可以使用这种方法:
INSERT INTO 目标表
(字段1, 字段2, ...)
SELECT 字段1, 字段2, ...
FROM 来源表
WHERE not exists (select * from 目标表
where 目标表.比较字段 = 来源表.比较字段);
从chargedevice导入chargedeviceTest中不存在的数据到chargedeviceTest表中
INSERT into chargedeviceTest SELECT * FROM chargedevice WHERE not EXISTS(SELECT * from chargedeviceTest WHERE chargedevice.id=chargedevicetest.id)
如果想只插入一条数据到chargedeviceTest中:
INSERT into chargedeviceTest SELECT * FROM chargedevice WHERE chargedevice.id=3338