A,B是结构一样的表,如果在A表No字段中的记录在B表中不存在,则把这条记录插入B表。
A:Name No Time ...
aa 1 ...
bb 2 ...
cc 3 ...B: Name No Time ...
aa 1 ...
gg 4 ...
ff 5 ...=>
B: Name No Time ...
aa 1 ...
bb 2 ...
cc 3 ...
gg 4 ...
ff 5 ...
???
A:Name No Time ...
aa 1 ...
bb 2 ...
cc 3 ...B: Name No Time ...
aa 1 ...
gg 4 ...
ff 5 ...=>
B: Name No Time ...
aa 1 ...
bb 2 ...
cc 3 ...
gg 4 ...
ff 5 ...
???
insert into B select * from A where No not in(select No from B)
(
select a.name,a.no,a.time from a
minus
select b.name,b.no,b.time from b
)
本人觉得用not in,在效率上有影响,速度不如minus快.
insert into b(name,no,time) select name,no,time from a,b where a.no<>b.no