a.id AS "id",
a.serial_num AS "serialNum",
a.year AS "year",
a.type AS "type",
a.quarter AS "quarter",
a.month AS "month",
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.status AS "status",
a.half AS "half"
INSERT INTO referee_ranking_schem(
id,
serial_num,
year,
type,
quarter,
month,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
status,
half
) VALUES (
#{id},
#{serialNum},
#{year},
#{type},
#{quarter},
#{month},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{status},
#{half}
)
UPDATE referee_ranking_schem SET
serial_num = #{serialNum},
year = #{year},
type = #{type},
quarter = #{quarter},
month = #{month},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
status = #{status},
half = #{half}
WHERE id = #{id}
UPDATE referee_ranking_schem SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
DELETE FROM referee_ranking_schem where serial_num = #{serialNum};
update referee_ranking_schem set STATUS = #{status} where id = #{id}