id, match_id, hotel_id, create_by, create_date, update_by, update_date, remarks, del_flag, show_location select from cku_match_hotel_relation where id = #{id,jdbcType=INTEGER} delete from cku_match_hotel_relation where id = #{id,jdbcType=INTEGER} insert into cku_match_hotel_relation (id, match_id, hotel_id, create_by, create_date, update_by, update_date, remarks, del_flag, show_location) values (#{id,jdbcType=INTEGER}, #{matchId,jdbcType=INTEGER}, #{hotelId,jdbcType=INTEGER}, #{createBy,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateBy,jdbcType=VARCHAR}, #{updateDate,jdbcType=TIMESTAMP}, #{remarks,jdbcType=VARCHAR}, #{delFlag,jdbcType=CHAR}, #{showLocation,jdbcType=VARCHAR}) insert into cku_match_hotel_relation id, match_id, hotel_id, create_by, create_date, update_by, update_date, remarks, del_flag, show_location, #{id,jdbcType=INTEGER}, #{matchId,jdbcType=VARCHAR}, #{hotelId,jdbcType=VARCHAR}, #{createBy,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateBy,jdbcType=VARCHAR}, #{updateDate,jdbcType=TIMESTAMP}, #{remarks,jdbcType=VARCHAR}, #{delFlag,jdbcType=CHAR}, #{showLocation,jdbcType=VARCHAR}, update cku_match_hotel_relation match_id = #{matchId,jdbcType=INTEGER}, hotel_id = #{hotelId,jdbcType=INTEGER}, create_by = #{createBy,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, update_by = #{updateBy,jdbcType=VARCHAR}, update_date = #{updateDate,jdbcType=TIMESTAMP}, remarks = #{remarks,jdbcType=VARCHAR}, del_flag = #{delFlag,jdbcType=CHAR}, show_location = #{showLocation,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update cku_match_hotel_relation set match_id = #{matchId,jdbcType=INTEGER}, hotel_id = #{hotelId,jdbcType=INTEGER}, create_by = #{createBy,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, update_by = #{updateBy,jdbcType=VARCHAR}, update_date = #{updateDate,jdbcType=TIMESTAMP}, remarks = #{remarks,jdbcType=VARCHAR}, del_flag = #{delFlag,jdbcType=CHAR}, show_location = #{showLocation,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} delete from cku_match_hotel_relation where match_id = #{matchId,jdbcType=VARCHAR} and hotel_id = #{hotelId,jdbcType=VARCHAR}