id, params_name, params_type, params_limit, create_time, interface_id,remarks select from test_params where id = #{id,jdbcType=INTEGER} delete from test_params where id = #{id,jdbcType=INTEGER} insert into test_params (id, params_name, params_type, params_limit, create_time, interface_id ) values (#{id,jdbcType=INTEGER}, #{paramsName,jdbcType=VARCHAR}, #{paramsType,jdbcType=VARCHAR}, #{paramsLimit,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{interfaceId,jdbcType=INTEGER} ) insert into test_params id, params_name, params_type, params_limit, create_time, interface_id, remarks, #{id,jdbcType=INTEGER}, #{paramsName,jdbcType=VARCHAR}, #{paramsType,jdbcType=VARCHAR}, #{paramsLimit,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{interfaceId,jdbcType=INTEGER}, #{remarks,jdbcType=VARCHAR}, SELECT LAST_INSERT_ID() AS id update test_params params_name = #{paramsName,jdbcType=VARCHAR}, params_type = #{paramsType,jdbcType=VARCHAR}, params_limit = #{paramsLimit,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, interface_id = #{interfaceId,jdbcType=INTEGER}, where id = #{id,jdbcType=INTEGER} update test_params set params_name = #{paramsName,jdbcType=VARCHAR}, params_type = #{paramsType,jdbcType=VARCHAR}, params_limit = #{paramsLimit,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, interface_id = #{interfaceId,jdbcType=INTEGER} where id = #{id,jdbcType=INTEGER} select from test_params where interface_id = #{interfaceId,jdbcType=INTEGER}