日期:2014-05-16  浏览次数:20483 次

批量添加、修改 (未完待续)
批量添加:
insert into A(a,b,c) select t.a,t.b,t.c from B t

批量修改:
update T1 set T1.A列=
(select T2.A列 from T2 where T2.B列=T1.A列 and rounum<=1)
where exists(select 1 from T2 where T2.B列=T1.A列 )  --加上这句,避免勿更新一些资料!