a.id AS "id",
a.module AS "module",
a.title AS "title",
a.img AS "img",
a.url AS "url",
a.type AS "type",
a.visible_flag AS "visibleFlag",
a.start_time AS "startTime",
a.end_time AS "endTime",
a.sort AS "sort",
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",
a.program_id AS "programId"
INSERT INTO breeder_banner(
id,
module,
title,
img,
url,
type,
visible_flag,
start_time,
end_time,
sort,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
program_id
) VALUES (
#{id},
#{module},
#{title},
#{img},
#{url},
#{type},
#{visibleFlag},
#{startTime},
#{endTime},
#{sort},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{programId}
)
UPDATE breeder_banner SET
module = #{module},
title = #{title},
img = #{img},
url = #{url},
type = #{type},
visible_flag = #{visibleFlag},
start_time = #{startTime},
end_time = #{endTime},
sort = #{sort},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
program_id = #{programId}
WHERE id = #{id}
UPDATE breeder_banner SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}