mysql防止插入重复数据

向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>