a.id AS "id",
a.exhibit_no AS "exhibitNo",
a.code AS "code",
a.position AS "position",
a.gender AS "gender",
a.class_no AS "classNo",
a.breed_no AS "breedNo",
a.group_no AS "groupNo",
a.contest_no AS "contestNo",
a.contest_event_no AS "contestEventNo",
a.display AS "display",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag"
INSERT INTO contest_winner(
id,
exhibit_no,
code,
position,
gender,
class_no,
breed_no,
group_no,
contest_no,
contest_event_no,
display,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{exhibitNo},
#{code},
#{position},
#{gender},
#{classNo},
#{breedNo},
#{groupNo},
#{contestNo},
#{contestEventNo},
#{display},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE contest_winner SET
exhibit_no = #{exhibitNo},
code = #{code},
position = #{position},
gender = #{gender},
class_no = #{classNo},
breed_no = #{breedNo},
group_no = #{groupNo},
contest_no = #{contestNo},
contest_event_no = #{contestEventNo},
display = #{display},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE contest_winner SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE contest_winner SET
exhibit_no = #{exhibitNo},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE code = #{code}
AND position = #{position}
AND gender = #{gender}
AND class_no = #{classNo}
AND breed_no = #{breedNo}
AND group_no = #{groupNo}
AND contest_no = #{contestNo}