id, inter_name, inter_url, inter_own, create_time,description,category_id,method
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,
description,
method,
category_id,
params,
#{id,jdbcType=INTEGER},
#{interName,jdbcType=VARCHAR},
#{interUrl,jdbcType=VARCHAR},
#{interOwn,jdbcType=VARCHAR},
#{createTime,jdbcType=TIMESTAMP},
#{description},
#{method},
#{categoryId},
#{params},
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},
description = #{description},
method = #{method},
category_id = #{categoryId}
where id = #{id,jdbcType=INTEGER}