id, referee_name, referee_nationality, referee_info, create_time select ref.id, ref.referee_name, ref.referee_nationality, ref.referee_info, ref.create_time from cku_match_referee ref left join cku_match_referee_relation relation ON ref.id = relation.referee_id where relation.show_location = #{showLocation,jdbcType=VARCHAR} delete from cku_match_referee where id = #{id,jdbcType=INTEGER} insert into cku_match_referee (id, referee_name, referee_nationality, referee_info, create_time) values (#{id,jdbcType=INTEGER}, #{refereeName,jdbcType=VARCHAR}, #{refereeNationality,jdbcType=VARCHAR}, #{refereeInfo,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}) insert into cku_match_referee id, referee_name, referee_nationality, referee_info, create_time, #{id,jdbcType=INTEGER}, #{refereeName,jdbcType=VARCHAR}, #{refereeNationality,jdbcType=VARCHAR}, #{refereeInfo,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, update cku_match_referee referee_name = #{refereeName,jdbcType=VARCHAR}, referee_nationality = #{refereeNationality,jdbcType=VARCHAR}, referee_info = #{refereeInfo,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, where id = #{id,jdbcType=INTEGER} update cku_match_referee set referee_name = #{refereeName,jdbcType=VARCHAR}, referee_nationality = #{refereeNationality,jdbcType=VARCHAR}, referee_info = #{refereeInfo,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=INTEGER}