代码如下,其中的123,456是自己要插入的值,按照这个格式写就可以了
insert into user (username,password)
select 123,456
from dual
where not exists (select * from user where username=123 and password=456)
代码如下,其中的123,456是自己要插入的值,按照这个格式写就可以了
insert into user (username,password)
select 123,456
from dual
where not exists (select * from user where username=123 and password=456)