a.id AS "id", a.question_id AS "questionId", a.is_right AS "isRight", a.option_id AS "optionId", a.option_content AS "optionContent", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.dt AS "dt", a.remarks AS "remarks", a.del_flag AS "delFlag" groomer_exam_questions_options SELECT FROM groomer_exam_questions_options a WHERE a.id = #{id} SELECT FROM groomer_exam_questions_options a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_exam_questions_options a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_exam_questions_options( id, question_id, is_right, option_id, option_content, create_by, create_date, update_by, update_date, dt, remarks, del_flag ) VALUES ( #{id}, #{questionId}, #{isRight}, #{optionId}, #{optionContent}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{dt}, #{remarks}, #{delFlag} ) UPDATE groomer_exam_questions_options SET question_id = #{questionId}, is_right = #{isRight}, option_id = #{optionId}, option_content = #{optionContent}, update_by = #{updateBy.id}, update_date = #{updateDate}, dt = #{dt}, remarks = #{remarks} WHERE id = #{id} UPDATE groomer_exam_questions_options SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select from a a.del_flag = '0' and a.question_id in #{questionId} select from a a.question_id in #{questionId}