insert into b(id, name, gender) select sn, name, gender from a where name not in (select name from b)
--tryinsert into B select * from A a where a.name not in ( select name from B); 上面的语句如果A和B的字段结构不一样的话,将不能执行。
是我描述有问题,就是更新B表根据B表中的名字,数据从A表中来,名字重复的不更新。 谢谢了
update b set ( b.sn , b.gendar) = ( select a.id ,a.gendar from a where a.name in ( select name from a group by a.name having count(a.name)<2 ) and a.name = b.name ) 暂时能够解决问题
insert into b(id, name, gender) select sn, name, gender from a where name not in (select name from b)
select * from A a where a.name not in ( select name from B);
上面的语句如果A和B的字段结构不一样的话,将不能执行。
谢谢了
(
select a.id ,a.gendar from a
where a.name in
( select name from a group by a.name having count(a.name)<2
)
and a.name = b.name
)
暂时能够解决问题