Mongodb使用记录

Mongodb使用记录

1.插入

1.1 单条数据的插入

db.comment.insert({"acticleid":"100000","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null})

1.2 多条数据的插入

db.comment.insertMany([{"acticleid":"100001","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null},{"acticleid":"100002","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null},{"acticleid":"100003","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null}])

1.3 try catch

try{
	db.comment.insertMany([{"acticleid":"100001","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null},{"acticleid":"100002","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null},{"acticleid":"100003","content":"good weather!","userid":"1001","nickname":"tom","createdatetime":new Date(),"linknum":NumberInt(10),"state":null}])
}catch(e){
	print(e);
}

2.查询

db.comment.find()

db.comment.find({"key":"value"})

db.comment.find({"key":"value"},{key:1,_id:0})

统计数量

db.comment.count()
db.comment.count({acticleid:"100002"})

升序/降序

db.comment.find().sort({userid:1})
db.comment.find().sort({userid:-1})

3.更新

db.collection.update(query, update, options)

3.1 覆盖的修改

db.comment.update({_id:"1"},{nickname:"jerry"})

3.2 局部的修改

db.comment.update({_id:"1"},{$set:{nickname:"jerry"}})

3.3 多条修改

db.comment.update({_id:"1"},{$set:{nickname:"jerry"}},{multi:true})

3.4

db.comment.update({_id:"1"},{$inc:{linknum:NumberInt(1)}})

4.删除

db.comment.remove(condition)

4.1 全部删除

db.comment.remove({})

4.2 按条件删除

db.comment.remove({_id:"1"})

5.索引

B-Tree