表中一定要有主键 :
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 )