a.id AS "id", a.rotation_index AS "rotationIndex", a.rotation_name AS "rotationName", a.rotation_picture AS "rotationPicture", a.rotation_explain AS "rotationExplain", a.rotation_type AS "rotationType", a.rotationCurriculum AS "rotationCurriculum", a.rotationHref AS "rotationHref", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.create_date AS "createDate", a.update_date AS "updateDate", a.del_flag AS "delFlag" SELECT FROM rotation_chart a WHERE a.id = #{id} SELECT FROM rotation_chart a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY CAST(a.rotation_index AS SIGNED ) DESC UPDATE rotation_chart SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} INSERT INTO rotation_chart( id, rotation_index, rotation_name, rotation_picture, rotation_explain, rotation_type, rotationHref, rotationCurriculum, create_by, create_date, update_by, update_date, del_flag ) VALUES ( #{id}, #{rotationIndex}, #{rotationName}, #{rotationPicture}, #{rotationExplain}, #{rotationType}, #{rotationHref}, #{rotationCurriculum}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{DEL_FLAG_NORMAL} ) UPDATE rotation_chart SET rotation_index=#{rotationIndex}, rotation_name=#{rotationName}, rotation_picture=#{rotationPicture}, rotation_explain=#{rotationExplain}, rotation_type=#{rotationType}, rotationHref=#{rotationHref}, rotationCurriculum=#{rotationCurriculum}, update_by = #{updateBy.id}, update_date = #{updateDate} WHERE id = #{id}