sql
if not exists (select * from uuv_user where userid='UR1100017647') insert into uuv_user (userid, username,displayname,telephone) values('UR1100017647', 'suxf','苏肖飞','')
oracle
insert into STAFF (STAFFID, LOGON_NAME,STAFF_NAME,PHONE,ROLEID,OWND_DEPARTMENTID)
select 'UR1100006887', 'huangpj2','黄沛江','076988875000','000100010001','OR1500021641'
from dual where not exists (select * from STAFF where STAFFID='UR1100006887')
if not exits
最新推荐文章于 2023-08-02 15:30:02 发布