表中一定要有主键 :
select :id,此处的id位置处必须是主键
1 insert into table_name(id, name, password)
2 select :id, :name, :password
3 from dual
4 where not exists (
5 select * from table_name
6 where id = :id )
表中一定要有主键 :
select :id,此处的id位置处必须是主键
1 insert into table_name(id, name, password)
2 select :id, :name, :password
3 from dual
4 where not exists (
5 select * from table_name
6 where id = :id )