a.id AS "id",
a.name AS "name",
a.member_code AS "memberCode",
a.photo AS "photo",
a.introduce AS "introduce",
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_handler(
id,
name,
member_code,
photo,
introduce,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{name},
#{memberCode},
#{photo},
#{introduce},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE show_handler SET
name = #{name},
member_code = #{memberCode},
photo = #{photo},
introduce = #{introduce},
update_by = #{updateBy.id},
update_date = #{updateDate}
WHERE id = #{id}
UPDATE show_handler SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}