ID_,NAME_,VALUE_,ALIAS_,LEVEL_,PARENT_ID_,TYPE_ID_,GROUP_TYPE_,PATH_,STATUS_,UPDATE_TIME_,IS_DELE_,VERSION_ SELECT FROM uc_user_rel WHERE ALIAS_=#{alias} AND IS_DELE_!='1' SELECT FROM uc_user_rel ${ew.customSqlSegment} SELECT FROM uc_user_rel where TYPE_ID_ = #{typeId} AND IS_DELE_!='1' ${authSql} select from uc_user_rel where type_id_ = #{typeId,jdbcType=VARCHAR} and parent_id_ = #{parentId,jdbcType=VARCHAR} and VALUE_ = #{value,jdbcType=VARCHAR} AND IS_DELE_!='1' DELETE FROM uc_user_rel WHERE IS_DELE_='1' UPDATE uc_user_rel SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE TYPE_ID_=#{typeId} select distinct relb.* from uc_user_rel rela left join uc_user_rel relb on rela.PARENT_ID_ = relb.ID_ where relb.ID_ is not null and rela.STATUS_=1 and relb.STATUS_=1 AND rela.IS_DELE_!='1' AND relb.IS_DELE_!='1' ${whereSql} select * from uc_user_rel rela where rela.STATUS_=1 AND rela.IS_DELE_!='1' ${whereSql} UPDATE uc_user_rel SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE PATH_ like #{path} SELECT FROM uc_user_rel where PARENT_ID_ = #{parentId} AND IS_DELE_!='1'