id, inter_name, inter_url, inter_own, create_time
delete from test_interface
where id = #{id,jdbcType=INTEGER}
insert into test_interface (id, inter_name, inter_url,
inter_own, create_time)
values (#{id,jdbcType=INTEGER}, #{interName,jdbcType=VARCHAR}, #{interUrl,jdbcType=VARCHAR},
#{interOwn,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP})
insert into test_interface
id,
inter_name,
inter_url,
inter_own,
create_time,
#{id,jdbcType=INTEGER},
#{interName,jdbcType=VARCHAR},
#{interUrl,jdbcType=VARCHAR},
#{interOwn,jdbcType=VARCHAR},
#{createTime,jdbcType=TIMESTAMP},
SELECT LAST_INSERT_ID() AS id
update test_interface
inter_name = #{interName,jdbcType=VARCHAR},
inter_url = #{interUrl,jdbcType=VARCHAR},
inter_own = #{interOwn,jdbcType=VARCHAR},
create_time = #{createTime,jdbcType=TIMESTAMP},
where id = #{id,jdbcType=INTEGER}
update test_interface
set inter_name = #{interName,jdbcType=VARCHAR},
inter_url = #{interUrl,jdbcType=VARCHAR},
inter_own = #{interOwn,jdbcType=VARCHAR},
create_time = #{createTime,jdbcType=TIMESTAMP}
where id = #{id,jdbcType=INTEGER}