新增或更新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 );