mongodb常用指令

查看索引

db.getCollection('wx_contacts_inf_102').getIndexes()

新建索引

db.getCollection('wx_contacts_inf_102').createIndex({"delete_flag":1})

db.getCollection('wx_contacts_inf_102').createIndex({'unionid':-1,'alias':-1,'mobile':-1})

删除索引

dropIndex({firstname:1})

eq：匹配等于指定值的值。 =

gt：匹配大于指定值的值。 >

gte：匹配大于或等于指定值的值。>=

lt：匹配小于规定值的值。 <

lte：匹配是小于或等于规定值的值。<=

ne：匹配不等于指定值的所有值。!=

in：匹配任何在数组中指定的值。

nin：没有匹配数组中的规定值

sort 排序

skip 起始位置

limit 截止位置

添加字段

db.getCollection('consumption').update({}, {$set: {'delete_flag':0}}, {multi: true})

//修改某个字段的值

db.getCollection('consumption').update({'consumption_id': {$in:['yyt1544697235048','yyt1544254791007']}

}, {$set: {'delete_flag':1}}, {multi: true}

)

查看索引

db.getCollection('wx_contacts_inf_102').getIndexes()

新建索引

db.getCollection('wx_contacts_inf_102').ensureIndex({"delete_flag":1})

分页查询

db.getCollection('member_64').find({}).sort({'opencard_time':-1}).skip(0).limit(1);

in查询

db.getCollection('orders_102').find({'order_no':{'$in':['1512626454535']}})

是否为空查询

db.getCollection('member_64').find({'member_id':{$exists:false}});//空 ,true不为空

//存在且不为空""

db.getCollection('orders_102').find({'channel_id':{$nin:[null,""]}})

//条件查询,并修改数据(默认只更新第一条)

db.getCollection('wxtj_dailyreport').update(

{'channel_name':'8501'},

{'$set':{'invest_money':987}}

)

db.getCollection('wxtj_dailyreport').update(

{'company_id':102},

{'$set':{'invest_money':0}},

{multi:true} //多条

)

//分组查询,求和

db.getCollection('wxtj_day').aggregate([

{'$match':{

'company_id':102,

'sys_group_id':{'$in': ['1539107778168','1539486287127','1539107786221','1539106431780']},

'create_data':{'$gte':'1541001600000'}

}},

{'$group':{'_id':'$sys_group_id',num:{'$sum':'$invalid_num'}}

}

])

//根据字段分组查询,并计算指定字段的和

db.getCollection('wxtj_day').aggregate([

{'$match':{

'company_id':102,

'custom_id':462,

'create_data':{'$gte':'1543593600000'}

}

},

{'$group':{ '_id':'$custom_id',

order_num:{'$sum':'$order_num'},

order_total:{'$sum':'$order_total'},

invalid_num: {'$sum':'$invalid_num'},

invalid_toatl: {'$sum':'$invalid_toatl'}

}

}

])

db.getCollection('wx_contacts_inf_102').find({

'channel_id':{$nin:[null,""]},

'weixinid':{$nin:[null,""]},

'isfriend':1,

'create_date':{$gte:'1545382800000',$lte:'1545469200000'}

}).sort({'create_date':-1})

db.getCollection('wx_contacts_inf_102').find({

'channel_id':{$nin:[null,""]},

'weixinid':{$nin:[null,""]},

'sys_group_id':{$nin:[null,""]},

'custom_id':{$nin:[null,""]},

"channel_id" : "1534921211056",

'create_date':{$gte:'1546419600000',$lte:'1546506000000'}})

只会修改第一条发现的文档，如果你要修改多条相同的文档，则需要设置 multi 参数为 true。

db.col.update({'title':'MongoDB 教程'},{$set:{'title':'MongoDB'}},{multi:true})

db.getCollection('wxtj_dailyreport').update({'create_date':'2019-03-01','channel_name':'6081'},{$set:{'create_date':'2019-04-19'}},{multi:true})

db.getCollection('wxtj_day').find({'custom_id':462,'create_data':{$gte:'1543593600000'}})

db.getCollection('wx_weixin_inf').find({weixinid:{'$exists':true,'$ne':''}}).forEach(

function(item){

db.getCollection('wxtj_dailyreport').update(

{"weixinid":item.weixinid},

{$set:{"custom_type":item.custom_type}

},false,true)

}

)

db.getCollection('wxtj_dailyreport').aggregate([

{'$match':{'create_date':'2019-03-10','company_id':102}},

{'$group':{

'_id':{'channel_name':'$channel_name'},

'company_id':{'$last':'$company_id'},

'is_auto_matic':{'$last':'$is_auto_matic'}

}

},

])

db.getCollection('membership_102').find({'company_id':102,'member_id':{$in:[44166, 26068]},

'total_recharge':{$gt:0},

'total_consumption':{$gt:0}})

db.getCollection('consumption').aggregate([

{'$match':{'company_id':102}},

{'$group':{

'_id':{'member_id':'$member_id'}

}

},

])

db.getCollection('membership_102').find({$and:[{'company_id':102},

{$or:[{'total_recharge':{$gt:0}},

{'total_consumption':{$gt:0}},

{'member_id':{$in:[44166]}}

]

}]

})