a.id AS "id", a.member_type AS "memberType", a.member_id AS "memberId", a.member_code AS "memberCode", a.member_name AS "memberName", a.create_time AS "createTime", a.sync_time AS "syncTime", a.sync_status AS "syncStatus" SELECT FROM member_sync_task a WHERE a.id = #{id} SELECT FROM member_sync_task a ORDER BY ${page.orderBy} SELECT FROM member_sync_task a ORDER BY ${page.orderBy} INSERT INTO member_sync_task( id, member_type, member_id, member_code, member_name, create_time, sync_time, sync_status ) VALUES ( #{id}, #{memberType}, #{memberId}, #{memberCode}, #{memberName}, #{createTime}, #{syncTime}, #{syncStatus} ) UPDATE member_sync_task SET member_type = #{memberType}, member_id = #{memberId}, member_code = #{memberCode}, member_name = #{memberName}, create_time = #{createTime}, sync_time = #{syncTime}, sync_status = #{syncStatus} WHERE id = #{id} DELETE FROM member_sync_task WHERE id = #{id}