5 一些基本操作
db.users.update{{username:"master"},{$set:{hobby:{cities:["beijing","shanghai","shenzhen"],movies:["marvel","DC"]}}}}
db.users.find({"hobby.movies":"marvel"})
db.users.update({username:"master",{$push:{"hobby.movies":"Sony"}}})
db.users.addToSet({username:"master",{$push:{"hobby.movies":"Sony"}}})
db.users.remvoe({"hobby.cities":"beijing"})
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.number.insert(arr);
db.nubmers.find({num:500})
db.nubmers.find({num:{$gt:500}})
db.nubmers.find({num:{$lt:30}})
db.nubmers.find({num:{$gt:40,$lt:50}})
db.nubmers.find().limit(10)
db.nubmers.find().skip(10).limit(10)
db.nubmers.find().limit(10).skip(10)
db.nubmers.find($or:[{num:{$lt:50}},{num:{$gt:40}}])
db.number.updateMany({num:{$lt:40}},{$inc:{num:20}})
6 文档之间的关系
- 一对一(在mongodb中用内嵌文档体现一对一关系)
db.stus.insert(name:"master",{name:"worker"})
db.stus.insert(name:"master",{name:["worker1","worker2"]})
db.stus.insert({list:['apple','banana'],user_id: ObjectId("[对应表id]")});
db.teachers.insert([
{name:"teacher1"},
{name:"teacher2"},
{name:"teacher3"}
]);
db.stus.insert([
{
name:"student1".
tech_ids:[
teacher1_id,
teacher2_id
]
},{
name:"student2".
tech_ids:[
teacher2_id,
teacher3_id
]
}
]);
7 排列和投影
db.emp.find({}).sort({sal:1,empno:-1})
db.emp.find({},{sal:1,_id:0})
8 导入文件
mongoimport --db [数据库名] --collection [集合名] --type [文件类型] --headerline --file [文件路径]