select TRAEGER,count(TRAEGER) from CCMVBRFAUSW where FTIMESTAMP like '20211222%' group by TRAEGER

delete from CCMVBRFAUSW where TRAEGER='11' and FTIMESTAMP='20211222012802'

show full processlist

drop table svcllswrfcount

describe svcllswrfcount

select * from svcllswrfcount

select distinct LSWID,DOKDATNUM,RUECKFRAGETYPCODE from svcllswrfcount

select * from CCMVBRFAUSW where DOKDAT_DATNUM='20211221' and LSWID='BMD_NTCS'

describe CCMVBRFAUSW

select count(*) from CCMVBRFAUSW

create table SVCLLSWIDRFDATCOUNT as
select LSWID,DOKDAT_DATNUM as DOKDATNUM, RUECKFRAGETYPCODE, COUNT(RUECKFRAGETYPCODE) as RFCOUNT
  from CCMVBRFAUSW
 where RUECKFRAGETYPCODE is not null and RUECKFRAGETYPCODE!='' and EXTERN_JN='J'
 group by LSWID,DOKDAT_DATNUM,RUECKFRAGETYPCODE

describe SVCLLSWIDRFDATCOUNT

create unique index svcllswidrfdatcountunique on SVCLLSWIDRFDATCOUNT(LSWID,DOKDATNUM,RUECKFRAGETYPCODE)

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME in ('svcllswidrfdatcount','svcllswrfcount')

select count(*) from SVCLLSWIDRFDATCOUNT

select distinct LSWID from SVCLLSWIDRFDATCOUNT

select distinct DOKDATNUM from SVCLLSWIDRFDATCOUNT order by DOKDATNUM asc

describe svclexoffosvttag

select distinct CONCAT(TRAEGER,'_',DOKUMENT_DAT) as TRAEGER_DATNUM, GROUP_CONCAT(MELDUNGS_DATUM), count(DOKUMENT_DAT) as TD_COUNT from svclexoffosvttag group by TRAEGER,DOKUMENT_DAT order by TD_COUNT desc

create unique index svclexoffosvttagunique on svclexoffosvttag(TRAEGER,DOKUMENT_DAT)

describe topcf_temp_201910161902260640410

show tables like 'topcf%'

select distinct FTIMESTAMP from CCMVBRFAUSW

shutdown
