image_id, image_min_url, image_max_url, match_id, match_hotel_id, match_referee_id, match_venue_id, create_time,remarks,dog_class_id,showLocation_isTop select from cku_image where image_id = #{imageId,jdbcType=INTEGER} delete from cku_image where image_id = #{imageId,jdbcType=INTEGER} insert into cku_image (image_id, image_min_url, image_max_url, match_id, match_hotel_id, match_referee_id, match_venue_id, create_time) values (#{imageId,jdbcType=INTEGER}, #{imageMinUrl,jdbcType=VARCHAR}, #{imageMaxUrl,jdbcType=VARCHAR}, #{matchId,jdbcType=INTEGER}, #{matchHotelId,jdbcType=INTEGER}, #{matchRefereeId,jdbcType=INTEGER}, #{matchVenueId,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP}) insert into cku_image image_id, image_min_url, image_max_url, remarks, dog_class_id, match_id, match_hotel_id, match_referee_id, match_venue_id, create_time, showLocation, showLocation_isTop, #{imageId,jdbcType=INTEGER}, #{imageMinUrl,jdbcType=VARCHAR}, #{imageMaxUrl,jdbcType=VARCHAR}, #{remarks,jdbcType=VARCHAR}, #{dogClassId,jdbcType=VARCHAR}, #{matchId,jdbcType=VARCHAR}, #{matchHotelId,jdbcType=VARCHAR}, #{matchRefereeId,jdbcType=VARCHAR}, #{matchVenueId,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{showLocation,jdbcType=VARCHAR}, #{showLocationIsTop,jdbcType=VARCHAR}, update cku_image image_min_url = #{imageMinUrl,jdbcType=VARCHAR}, image_max_url = #{imageMaxUrl,jdbcType=VARCHAR}, match_id = #{matchId,jdbcType=INTEGER}, match_hotel_id = #{matchHotelId,jdbcType=INTEGER}, match_referee_id = #{matchRefereeId,jdbcType=INTEGER}, match_venue_id = #{matchVenueId,jdbcType=INTEGER}, create_time = #{createTime,jdbcType=TIMESTAMP}, showLocation_isTop=#{showLocationIsTop,jdbcType=VARCHAR}, where image_id = #{imageId,jdbcType=INTEGER} update cku_image set image_min_url = #{imageMinUrl,jdbcType=VARCHAR}, image_max_url = #{imageMaxUrl,jdbcType=VARCHAR}, match_id = #{matchId,jdbcType=INTEGER}, match_hotel_id = #{matchHotelId,jdbcType=INTEGER}, match_referee_id = #{matchRefereeId,jdbcType=INTEGER}, match_venue_id = #{matchVenueId,jdbcType=INTEGER}, create_time = #{createTime,jdbcType=TIMESTAMP} where image_id = #{imageId,jdbcType=INTEGER} ${sql} select image_id,image_max_url,image_min_url from cku_image where match_hotel_id=#{hotelId} select image_id,image_max_url,image_min_url from cku_image where match_venue_id=#{venueId}