新增或更新sql

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 );