SELECT * FROM uc_tenant_manage WHERE CODE_=#{code,jdbcType=VARCHAR} SELECT * FROM uc_tenant_manage WHERE TYPE_ID_=#{typeId,jdbcType=VARCHAR} and IS_DELE_ = '0' SELECT * FROM uc_tenant_manage WHERE 1=1 AND STATUS_=#{status,jdbcType=VARCHAR} AND TYPE_ID_=#{typeId,jdbcType=VARCHAR} SELECT * FROM uc_tenant_manage WHERE DOMAIN_=#{domain,jdbcType=VARCHAR} DELETE FROM uc_tenant_manage WHERE TYPE_ID_=#{typeId,jdbcType=VARCHAR} select * from ( select tm.*,tt.name_ "type_name_" from uc_tenant_manage tm left join uc_tenant_type tt on tm.type_id_ = tt.id_ where tm.IS_DELE_!='1' ) mq ${ew.customSqlSegment}