一、sql server数据库写法:
update a set a.ksgmm=b.ksgmm,a.ksgm=b.ksgm,a.scztm=b.scztm,a.sczt=b.sczt from landsde.sde.jszb a,kyqcldb.dbo.kcl_ksjj b
where a.nd=b.nd and a.kqbh=b.kqbh and a.djflbh =b....
1,创建符合条件的A,B表和数据
create table IF not EXISTS A (id int auto_increment primary key);create table IF not EXISTS B (id int auto_increment primary key);
insert into A values();insert into A ...