mongodb常用语句

待我称王封你为后i 2022-11-01 00:52 109阅读 0赞

db.wd\_monitor\_data\_202012.find(\{timeKey:/20201209/\})

db.stats(1073741824);

db.wd\_monitor\_data\_202101.find()  
db.wd\_monitor\_data\_202101.find(\{schemaId:"187",timeKey:/^20210113/\})  
db.channel\_succ\_rate\_history.distinct("schemaId")

db.wd\_monitor\_data\_202012.find(\{schemaId:"1000"\}).count(1)

db.wd\_monitor\_data\_hour\_202101.find(\{schemaId:"1",timeKey:"20210101010000"\})  
db.wd\_monitor\_data\_day\_202101.distinct("schemaId")

db.wd\_monitor\_data\_hour\_202101.distinct("schemaId")  
db.wd\_monitor\_data\_hour\_202012.distinct("schemaId")  
db.wd\_monitor\_data\_202101.distinct("schemaId")  
db.wd\_monitor\_data\_202101.find(\{schemaId:"165"\})

db.wd\_monitor\_data\_hour\_202012.find()  
db.wd\_monitor\_data\_hour\_202101.find(\{timeKey:"20210113160000",schemaId:"4",col1:"HYL09010101"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^20210131/,schemaId:"4",col2:"4195",col1:"CUPWK03031201"\})  
db.wd\_monitor\_data\_hour\_202101.find(\{timeKey:/^20210131/,schemaId:"4",col2:"4195",col1:"CUPWK03031201"\})  
db.wd\_monitor\_data\_day\_202101.find(\{timeKey:/^20210130/,col2:"4195",col1:"CUPWK03031201"\})

db.wd\_monitor\_data\_day\_202101.find(\{timeKey:/^20210131/,col1:/^CUPWK0303/,col5:"PB521027"\})  
db.wd\_monitor\_data\_day\_202101.find(\{timeKey:/^20210131/,col1:/^CUPWK0303/,col5:"PB520005"\})

db.wd\_monitor\_data\_day\_202101.find(\{timeKey:/^20210131/,col1:/^CUPWK03030101/,schemaId:"4",col2:"4195"\})

db.wd\_monitor\_data\_hour\_202012.find()  
db.wd\_monitor\_data\_hour\_202101.find(\{timeKey:"20210113160000",schemaId:"1",col1:"HYL09010101"\})

db.wd\_monitor\_data\_202101.find(\{schemaId:"1000"\})  
db.wd\_monitor\_data\_202102.find(\{timeKey:/^20210214/,schemaId:"3",col1:"COMMCQ0901"\})  
db.wd\_monitor\_data\_202102.find(\{timeKey:/^2021021/,schemaId:"1000",transCode:"COMMCQ0901"\})  
db.wd\_monitor\_data\_202102.find(\{timeKey:/^20210214/,schemaId:"1000"\})

db.wd\_monitor\_data\_day\_202101.find(\{timeKey:/^20210131/,schemaId:"1",col2:"4195",col1:"CUPWK03031201"\})

db.wd\_monitor\_data\_202101.aggregate(\[\{$match:\{timeKey:/^2021011316/,schemaId:"1",col2:"4003",col1:"HYL09010101"\}\},\{ $group :\{ \_id : null, "count":\{"$sum":"$result"\}\}\}\])  
.find(\{timeKey:/^2021011316/,schemaId:"1",col2:"4003",col1:"HYL09010101"\})  
for (var i = 1; i <= 10; i++)

db.test.insert( \{ x : i , name: "Liqing" , class:"1120", sex:"woman"\} )

db.wd\_monitor\_data\_202101.find(\{timeKey:/^2021011316/,schemaId:"1",col2:"4003",col1:"HYL09010101"\}).forEach(function(obj) \{   
    obj.salary = new NumberInt(obj.result);  
    db.db\_name.save(obj);  
\});

ZCHHBANK13010401  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^20210118124/,schemaId:"187",col1:"ZCHHBANK13010401"\})

db.wd\_monitor\_data\_hour\_202101.find(\{timeKey:"20210118150000",col1:"CUP04010401"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^202101150235/,schemaId:"1",col1:"EPCC03030101",col2:"4043"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^202101150235/,schemaId:"3",col1:"EPCC03030101",col2:"4043"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^202101150235/,schemaId:"4",col1:"EPCC03030101",col2:"4043"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^202101150235/,schemaId:"1000"，transCode:"EPCC03030101",frontBankCode:"4043"\})

db.wd\_monitor\_data\_202101.find(\{timeKey:/^202101150235/,schemaId:"4",col1:"EPCC03030101"\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^2021012521/,schemaId:"166",col1:/^XABANK1301/\})  
db.wd\_monitor\_data\_202101.find(\{timeKey:/^20210125/,schemaId:"168",col1:/^XABANK1301/\})

db.wd\_monitor\_data\_202101.find(\{timeKey:/^2021012521/,schemaId:"1000"，transCode:/^XABANK1301/\})

db.wd\_monitor\_data\_hour\_202101.find()  
db.wd\_monitor\_data\_hour\_202101.find(\{schemaId:"4",col5:"PB521025"\})  
db.wd\_monitor\_data\_hour\_202101.count(\{schemaId:"1"\})  
db.wd\_monitor\_data\_hour\_202101.aggregate(\{ $group :\{ \_id : null, "count":\{"$sum":"$schemaId"\}\}\})

db.wd\_monitor\_data\_hour\_202101.find(\{col1:"HYL09010101",col2:"4003",timeKey:"20210120150000"\})  
db.channel\_succ\_rate\_history.find(\{col1:"HYL09010101",col2:"4003"\})