mongodb

筛选

db.getCollection("Department").find({DepartmentId:{$exists:true}})
db.getCollection("tester").aggregate(
[{$group: {_id: "$testerName",count:{$sum:1}}},
 {$match: {count:{$gt:1}}}]
)

子元素匹配

# 其中state_arr为数组，包含多个字典
db.user.find({state_arr:{$elemMatch:{id:1}}})
#通过元素下标来查找和替换
db.getCollection("abc").updateMany({"services.35.build_goals_and_options":"U"},{$set:{"services.35.build_goals_and_options":""}});
#循环替换子元素
for(var i=0; i<=30; i++){
    db.getCollection("abc").updateMany({[`services.${i}.build_goals_and_options`]:"U"},{$set:{[`services.${i}.build_goals_and_options`]:""}});
}

删除

db.getCollection("tester").deleteMany({name:{$ne:"XXX"}})

更新

db.getCollection("students").updateMany({role:"teacher"},{$set:{age:"30"}})

Refer

https://blog.csdn.net/hayre/article/details/80628431?utm_medium=distribute.pc_relevant.none-task-blog-baidujs_title-4&spm=1001.2101.3001.4242

比较

db.user.find({money:{$gt:“2000”}})

缩写	解释	运算符
$gt	greater than	>
$gte	greater than equal	>=
$lt	less than	<
$lte	less than	<=
$ne	not equal	!=
$eq	equal	=

操作

show dbs // 显示数据库列表  
use demo // 创建，切换到demo数据库,要有数据才会显示在数据库列表中  
db.createCollection("goods") // 创建goods集合
db.goods.insert({id:123,name:'hello'}) // 给goods集合插入数据
db.goods.find() // 查看goods集合下的数据
mongoimport --db demo --collection goods --file E:\nodeJs\goods.json  //导入文件