INSERT INTO tlk_course_auth_base_info (`PARENT`,
  `LASTMODIFIED`,
  `FORMNAME`,
  `STATE`,
  `AUDITUSER`,
  `AUDITDATE`,
  `AUTHOR`,
  `AUTHOR_DEPT_INDEX`,
  `CREATED`,
  `FORMID`,
  `ISTMP`,
  `VERSIONS`,
  `APPLICATIONID`,
  `STATEINT`,
  `STATELABEL`,
  `AUDITORNAMES`,
  `LASTFLOWOPERATION`,
  `LASTMODIFIER`,
  `DOMAINID`,
  `AUDITORLIST`,
  `COAUDITORLIST`,
  `STATELABELINFO`,
  `PREVAUDITNODE`,
  `PREVAUDITUSER`,
  `OPTIONITEM`,
  `SIGN`,
  `KINGGRIDSIGNATURE`,
  `ITEM_AUTHLESSONNAME`,
  `ITEM_AUTHLESSONID`,
  `ID`,
  `ITEM_AUTHUSERID`,
  `ITEM_AUTHUSERNAME`,
  `ITEM_AUTHRECORDID`,
  `ITEM_VALIDITYDATE`,
  `ITEM_PROGRESS`,
  `ITEM_STUDIED`,
  `ITEM_ISNEXTC`,
  `ITEM_ISNEXTS`,
  `ITEM_LEARNPERMISSION`,
  `ITEM_DOID`,
  `ITEM_AUTHLESSONCOVER`,
  `ITEM_REMARK`
)  SELECT `PARENT`,
  `LASTMODIFIED`,
  `FORMNAME`,
  `STATE`,
  `AUDITUSER`,
  `AUDITDATE`,
  `AUTHOR`,
  `AUTHOR_DEPT_INDEX`,
  `CREATED`,
  `FORMID`,
  `ISTMP`,
  `VERSIONS`,
  `APPLICATIONID`,
  `STATEINT`,
  `STATELABEL`,
  `AUDITORNAMES`,
  `LASTFLOWOPERATION`,
  `LASTMODIFIER`,
  `DOMAINID`,
  `AUDITORLIST`,
  `COAUDITORLIST`,
  `STATELABELINFO`,
  `PREVAUDITNODE`,
  `PREVAUDITUSER`,
  `OPTIONITEM`,
  `SIGN`,
  `KINGGRIDSIGNATURE`,
  `ITEM_AUTHLESSONNAME`,
  `ITEM_AUTHLESSONID`,
  `ID`,
  `ITEM_AUTHUSERID`,
  `ITEM_AUTHUSERNAME`,
  `ITEM_AUTHRECORDID`,
  `ITEM_VALIDITYDATE`,
  `ITEM_PROGRESS`,
  `ITEM_STUDIED`,
  `ITEM_ISNEXTC`,
  `ITEM_ISNEXTS`,
  `ITEM_LEARNPERMISSION`,
  `ITEM_DOID`,
  `ITEM_AUTHLESSONCOVER`,
  `ITEM_REMARK` FROM tlk_lesson_auth_base_info where id not in(select id from tlk_course_auth_base_info)