a.id AS "id", a.show_code AS "showCode", a.register_id AS "registerId", a.payment_member_code AS "paymentMemberCode", a.member_code AS "memberCode", a.grade_write AS "gradeWrite", a.grade_time AS "gradeTime", a.start_exam_time AS "startExamTime", a.end_exam_time AS "endExamTime", a.exam_time AS "examTime", 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", a.answer_info AS "answerInfo", a.current_exam_paper AS "currentExamPaper", a.commit_exam_type AS "commitExamType", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.running_number AS "runningNumber", a.exam_paper_id AS "examPaperId", a.written_exam_status AS "writtenExamStatus", a.auto_close_time AS "autoCloseTime", a.last_selected_time AS "lastSelectedTime", a.order_code AS "orderCode" id, show_code, register_id, payment_member_code, member_code, grade_write, grade_time , start_exam_time, end_exam_time, exam_time, create_by, create_date, update_by, update_date, dt, remarks, del_flag, answer_info, current_exam_paper, commit_exam_type, payment_state, payment_time, running_number, exam_paper_id, written_exam_status, auto_close_time, last_selected_time, order_code groomer_written_exam_info SELECT FROM groomer_written_exam_info a WHERE a.id = #{id} SELECT FROM groomer_written_exam_info a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_written_exam_info a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_written_exam_info( id, show_code, register_id, payment_member_code, member_code, grade_write, grade_time, start_exam_time, end_exam_time, exam_time, create_by, create_date, update_by, update_date, remarks, del_flag, answer_info, current_exam_paper, commit_exam_type, payment_state, payment_time, running_number, exam_paper_id, written_exam_status, auto_close_time, last_selected_time, order_code ) VALUES ( #{id}, #{showCode}, #{registerId}, #{paymentMemberCode}, #{memberCode}, #{gradeWrite}, #{gradeTime}, #{startExamTime}, #{endExamTime}, #{examTime}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{answerInfo}, #{currentExamPaper}, #{commitExamType}, #{paymentState}, #{paymentTime}, #{runningNumber}, #{examPaperId}, #{writtenExamStatus}, #{autoCloseTime}, #{lastSelectedTime}, #{orderCode} ) UPDATE groomer_written_exam_info SET show_code = #{showCode}, register_id = #{registerId}, payment_member_code = #{paymentMemberCode}, member_code = #{memberCode}, grade_write = #{gradeWrite}, grade_time = #{gradeTime}, start_exam_time = #{startExamTime}, end_exam_time = #{endExamTime}, exam_time = #{examTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, answer_info = #{answerInfo}, current_exam_paper = #{currentExamPaper}, commit_exam_type = #{commitExamType}, payment_state = #{paymentState}, payment_time = #{paymentTime}, running_number = #{runningNumber}, exam_paper_id = #{examPaperId}, written_exam_status = #{writtenExamStatus}, auto_close_time = #{autoCloseTime}, last_selected_time = #{lastSelectedTime}, order_code = #{orderCode} WHERE id = #{id} UPDATE groomer_written_exam_info SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select from a a.del_flag = '0' and a.register_id = #{registerId} and a.member_code = #{memberCode} order by a.create_date desc limit 0,1 select from a a.del_flag = '0' and a.register_id = #{registerId} and a.member_code = #{memberCode} and commit_exam_type is not null order by a.create_date desc select from a JOIN (SELECT max(create_date) as create_date from groomer_written_exam_info del_flag = '0' and member_code = #{memberCode} and commit_exam_type is not null and register_id in #{registerId} GROUP BY register_id ) b on b.create_date = a.create_date