----只向目的表中复制不重复的行 insert into 目的表 select a.* from 源表 as a LEFT JOIN 目的表 as b on a.主键 = b.主键 WHERE b.主键 IS NULL
如何将两个表结构完全相同的数据库中的数据导到一个数据库中? 两个数据库中有重复的数据。1如果重复的以A库的为准,可以 insert a..tablename(...) select ... from b..tablename b where not exists ( select 1 from a..tablename where 主键=b.主键 ) --合并的放在A库或者 update b set ... --主键外的字段都要写 from a..tablename a,b..tablename b where a.主键=b.主键insert b..tablename(...) select ... from a..tablename a where not exists ( select 1 from b..tablename where 主键=a.主键 ) --合并的放在B库2反之,以B库的为准,可以 insert b..tablename(...) select ... from a..tablename a where not exists ( select 1 from b..tablename where 主键=a.主键 ) --合并的放在B库或者 update a set ... --主键外的字段都要写 from a..tablename a,b..tablename b where a.主键=b.主键insert a..tablename(...) select ... from b..tablename b where not exists ( select 1 from a..tablename where 主键=b.主键 ) --合并的放在A库
insert into 目的表
select a.* from 源表 as a
LEFT JOIN 目的表 as b on a.主键 = b.主键
WHERE b.主键 IS NULL
两个数据库中有重复的数据。1如果重复的以A库的为准,可以
insert a..tablename(...) select ... from b..tablename b
where not exists (
select 1 from a..tablename
where 主键=b.主键
)
--合并的放在A库或者
update b
set ... --主键外的字段都要写
from a..tablename a,b..tablename b
where a.主键=b.主键insert b..tablename(...) select ... from a..tablename a
where not exists (
select 1 from b..tablename
where 主键=a.主键
)
--合并的放在B库2反之,以B库的为准,可以
insert b..tablename(...) select ... from a..tablename a
where not exists (
select 1 from b..tablename
where 主键=a.主键
)
--合并的放在B库或者
update a
set ... --主键外的字段都要写
from a..tablename a,b..tablename b
where a.主键=b.主键insert a..tablename(...) select ... from b..tablename b
where not exists (
select 1 from a..tablename
where 主键=b.主键
)
--合并的放在A库