update sat_taxpayer set nsrmc='AAAA'
where nsrsbh = '110107751318780' ;
insert into sat_taxpayer(remarkid, nsrsbh)
select '999', '110107751318780' from dual
where ('110107751318780') not in (select nsrsbh from sat_taxpayer );
新增或更新sql
最新推荐文章于 2024-05-17 04:53:32 发布