a.id AS "id",
a.judge_certificate_mian AS "judgeCertificateMian",
a.judge_certificate AS "judgeCertificate",
a.sign_date AS "signDate",
a.end_date AS "endDate",
a.group_no AS "groupNo",
a.visible_flag AS "visibleFlag",
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 show_judge_certificate_dog_group(
id,
judge_certificate_mian,
judge_certificate,
sign_date,
end_date,
group_no,
visible_flag,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{judgeCertificateMian},
#{judgeCertificate},
#{signDate},
#{endDate},
#{groupNo},
#{visibleFlag},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE show_judge_certificate_dog_group SET
judge_certificate_mian = #{judgeCertificateMian},
judge_certificate = #{judgeCertificate},
sign_date = #{signDate},
end_date = #{endDate},
group_no = #{groupNo},
visible_flag = #{visibleFlag},
del_flag = #{delFlag},
update_by = #{updateBy.id},
remarks = #{remarks},
update_date = #{updateDate}
WHERE id = #{id}
UPDATE show_judge_certificate_dog_group SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}