ID_, CATALOG_ID_, NAME_, CODE_, DESCRIPTION_, DB_ALIAS_, LEVEL_, UPDATE_RATE_, IS_DATABASE_, IS_API_, IS_FILE_, TABLE_NAME_CH_, TABLE_NAME_EN_, TABLE_DESC_, TABLE_CODE_, IS_CREATE_TABLE_, CREATE_TABLE_SQL_, FIELD_TOTAL, TOTAL_NUM_, INCREMENT_TIMEKEY, SYNC_TYPE_, INCREMENT_MAXTIME_, DATAFILE_DOWN_URL_, DEPLOYED_STATUS_, DEPLOYED_TIME_, DEPLOYED_USERNAME_, SN_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, IS_DELE_, TENANT_ID_ update BIZ_SHARE_TABLE set CATALOG_ID_ = #{catalogId} where ID_ in #{id} select * from BIZ_SHARE_TABLE t inner join BIZ_SCHEDULER_JOB_TABLE jt on t.id_=jt.TABLE_ID_ where jt.JOB_ID_=#{jobId} SELECT t1.* FROM ( SELECT * FROM biz_share_table t WHERE t.IS_DELE_ = '0' AND t.DEPLOYED_STATUS_ = '1' AND t.ID_ NOT IN ( SELECT au.TABLE_ID_ FROM biz_share_auth au WHERE au.MEMBER_ID_ = #{consumerId} AND au.RESOURCE_ID_ IS NULL )) t1 ${ew.customSqlSegment}