mysql 避免重复插入数据

来源:互联网 发布:mysql 查看数据库路径 编辑:程序博客网 时间:2024/05/21 11:11
INSERT INTO t_wechat_follower (FollowerId, CustomerId, CreateDate,  OpenId  )
SELECT 
 #{followerid,jdbcType=INTEGER}, #{customerid,jdbcType=INTEGER}, #{createdate,jdbcType=TIMESTAMP},  #{openid,jdbcType=VARCHAR}
FROM dual WHERE NOT EXISTS (SELECT 1 FROM t_wechat_follower WHERE openid = #{openid,jdbcType=VARCHAR} and customerid = # {customerid,jdbcType=INTEGER});
0 0
原创粉丝点击