a.id AS "id", a.member_code AS "memberCode", a.sql_info AS "sqlInfo", a.content AS "content", a.order_no AS "orderNo", a.create_time AS "createTime", a.update_time AS "updateTime", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.source AS "source" SELECT FROM sys_member_kennel_modify_log a WHERE a.id = #{id} SELECT FROM sys_member_kennel_modify_log a ORDER BY ${page.orderBy} SELECT FROM sys_member_kennel_modify_log a ORDER BY ${page.orderBy} INSERT INTO sys_member_kennel_modify_log( member_code, sql_info, content, order_no, create_time, update_time, create_by, update_by, source ) VALUES ( #{memberCode}, #{sqlInfo}, #{content}, #{orderNo}, #{createTime}, #{updateTime}, #{createBy.id}, #{updateBy.id}, #{source} ) UPDATE sys_member_kennel_modify_log SET member_code = #{memberCode}, sql_info = #{sqlInfo}, content = #{content}, order_no = #{orderNo}, create_time = #{createTime}, update_time = #{updateTime}, update_by = #{updateBy.id}, source = #{source} WHERE id = #{id} DELETE FROM sys_member_kennel_modify_log WHERE id = #{id}