<insert id="insertNotExists" >
insert into tf_app_call_count (id,api_key,
api_secret, api_id,
create_time, update_time, create_user,
update_user, valid) SELECT
#{id,jdbcType=BIGINT}, #{apiKey,jdbcType=VARCHAR},
#{apiSecret,jdbcType=VARCHAR}, #{apiId,jdbcType=VARCHAR},
#{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{createUser,jdbcType=BIGINT},
#{updateUser,jdbcType=BIGINT}, #{valid,jdbcType=BIT}
from dual where not exists(select id
insert into tf_app_call_count (id,api_key,
api_secret, api_id,
create_time, update_time, create_user,
update_user, valid) SELECT
#{id,jdbcType=BIGINT}, #{apiKey,jdbcType=VARCHAR},
#{apiSecret,jdbcType=VARCHAR}, #{apiId,jdbcType=VARCHAR},
#{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{createUser,jdbcType=BIGINT},
#{updateUser,jdbcType=BIGINT}, #{valid,jdbcType=BIT}
from dual where not exists(select id