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});
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});