Sql代码 insert into tt(name,password) select 'phl','123' from dual where not exists(select * from tt where name='phl' and password='123') insert into tt(name,password) select 'phl','123' from dual where not exists(select * from tt where name='phl' and password='123')这个SQL语句的含义是,如果插入的数据 name='phl',password='123'不存在,则执行插入;
MYSQL 插入数据防止重复
最新推荐文章于 2023-01-18 11:59:35 发布