oracle :
insert
when (not exists (select id from t_company_staff where name='赵国军4')) then
into t_company_staff (name,status,APPLIEDTYPE) select '赵国军4',2,1 from dual;
或者
insert
into t_company_staff
(name,status,APPLIEDTYPE) select '赵国军4',2,1 from dual where not exists (select id from t_company_staff where name='赵国军4')
postgresql:
insert
into t_company_staff
(name,status,APPLIEDTYPE) select '赵国军4',2,1 from dual where not exists (select id from t_company_staff where name='赵国军4')
注意:并发高的时候,可以尝试加睡眠时间来优化限制