向mysql数据库中插入数据防止插入重复数据
insert into 不存在时 插入数据
1.sql语句
Insert into person (`name`,`age`)select 'zhangsan',18 from DUAL
where not exists (select * from person where `name` = 'zhangsan' and `age`=18)
2.mybatis语句
<insert id="insertPerson" parameterType="com.future.Person" userGeneratedKeys="true" keyProperty="id">
insert into person (`name`,`age`) select #{name},#{age} from DUAL where not exists (select * from person where `name` = #{name} and `age`=#{age})
</insert>