mongodb常用语句_mongodb的语句-CSDN博客

本文链接：https://blog.csdn.net/qq_32907195/article/details/113989094

这篇博客展示了多种MongoDB的数据查询操作，包括按时间Key、schemaId、col1和col2等字段进行筛选、聚合及计数，还涉及到了数据插入、更新和特定模式的查找。内容涵盖wd_monitor_data集合不同时间段的数据查询，以及一些具体的业务场景应用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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"})