1.进入test数据库
use test
2.在数据库中插入一个文档
db.persons.insert({
username:"xiaohao"
});
3.查询数据库中的文档
db.persons.find();
4.统计文档数量
db.persons.find().count();
5.查询username为xiaohao的文档
db.persons.find({username:"xiaohao"});
6.在persons集合中username为xiaohao的文档添加一个属性,age为23
db.persons.update({username:"xiaohao"},{$set:{age:23}});
7.替换所有username:xiaohao为username:shawn
db.persons.update({username:"xiaohao"},{$set:{username:"shawn"}});
8.替换第一个username:xiaohao为username:shawn
db.persons.replaceOne({username:"xiaohao"},{username:"shawn"});
db.persons.updateOne({username:"xiaohao"},{$set:{username:"shawn"}});
9.删除username:xiaohao属性age
db.persons.update({username:"xiaohao"},{$unset:{age:""}})
10.在username:xiaohao的文档中添加info:{cities:["shanghai","changsha","shengzhen"],sports:["baseball","run"]}
db.persons.update({username:"xiaohao"},{$set:{info:{cities:["shanghai","changsha","shengzhen"],sports:["football","run"]}}})
11.查询包含run的文档
db.persons.find({"info.sports":"run"}); or db.persons.find({'info.sports':"run"});
12.在上面10题中的sports中添加basketball
db.persons.update({username:"xiaohao"},{$push:{"info.sports":"basketball"}});#push会重复添加
db.persons.update({username:"xiaohao"},{$addToSet:{"info.sports":"basketball"}});#addToSet不会重复添加
13.删除sports中有run的文档
db.persons.remove({"info.sports":"run"})
14.删除persons集合
db.persons.remove({})
db.persons.drop();
15.向numbers插入20000数据
for(var i=1;i<=20000;i++){
db.numbers.insert({num:i})
}
性能优化,只操作一次数据库
var arr=[];
for(var i=1;i<=20000;i++){
arr.push({num:i})
};
db.numbers.insert(arr);