MongoDB 在windows shell环境下的基本操作和命令的使用示例(三)

1，原来的数据集合testcoll删掉，建立新的数据集合testcoll如下;

db.testcoll.insert({"num":1,"name":"李一","age":18,"sex":"male","job":"worker","salares":300,"score":12})
db.testcoll.insert({"num":2,"name":"没大","age":33,"sex":"female","job":"manager","salares":8000,"score":100})
db.testcoll.insert({"num":3,"name":"王五","age":80,"sex":"male","job":"worker","salares":300000,"score":80})
db.testcoll.insert({"num":4,"name":"赵六","age":12,"sex":"male","job":"engineer","salares":100,"score":90})
db.testcoll.insert({"num":5,"name":"左奔","age":20,"sex":"female","job":"worker","salares":2000,"score":80})


db.testcoll.insert({"num":6,"name":"及二","age":28,"sex":"male","job":"fda","salares":1000,"score":100})
db.testcoll.insert({"num":7,"name":"张三","age":38,"sex":"female","job":"dddd","salares":30000000,"score":0})
db.testcoll.insert({"num":8,"name":"李四","age":48,"sex":"male","job":"cccc","salares":32100,"score":0})
db.testcoll.insert({"num":9,"name":"木程","age":98,"sex":"male","job":"worker","salares":21000,"score":60})
db.testcoll.insert({"num":10,"name":"之力","age":8,"sex":"female","job":"manager","salares":3200,"score":50})


db.testcoll.insert({"num":11,"name":"工作","age":23,"sex":"male","job":"engineer","salares":300,"score":40})
db.testcoll.insert({"num":12,"name":"压力","age":34,"sex":"female","job":"wfa","salares":3020,"score":0})
db.testcoll.insert({"num":13,"name":"脸左","age":45,"sex":"male","job":"wfdafar","salares":20000,"score":20})
db.testcoll.insert({"num":14,"name":"顶级","age":32,"sex":"male","job":"wofdafda","salares":10000,"score":21})

2,对集合求mod操作，$mode,[can1,can2],表示对该字段求can1的模，余数是can2,下面两种方式都可以，结果如下截图
db.testcoll.find( { num: { $mod: [ 4, 0 ] } } ).pretty()
db.testcoll.find( { "num": { "$mod": [ 4, 0 ] } } ).pretty()

3，范围操作：$in  ,$nin,
在集合testcoll中找到name是张三，李四，工作的人
db.testcoll.find({"name":{"$in":["张三","李四","工作"]}}).pretty()

在集合testcoll中找到name不是张三，李四，工作的人
db.testcoll.find({"name":{"$nin":["张三","李四","工作"]}}).pretty()
4,数组操作查询，在集合中增加数组
db.testcoll.insert({"num":15,"name":"顶级","age":32,"sex":"male","job":"wofdafda","salares":10000,"score":21,"course":["语文","数学","英语"]})
db.testcoll.insert({"num":16,"name":"顶级","age":22,"sex":"female","job":"wofdafsda","salares":5000,"score":221,"course":["语文","数学","英语","meishu"]})
查询同时参加语文和数学的学生
db.testcoll.find({"course":{"$all":["语文","数学"]}}).pretty()

也可以单个查询：
db.testcoll.find({"age":{"$all":[18]}}).pretty()

用数组索引进行查询，索引从0下标开始
db.testcoll.find({"course.1":"数学"}).pretty()

查询只参加三门课的学生
db.testcoll.find({"course":{"$size":3}}).pretty()

查询年纪22，取课程前两门的信息
db.testcoll.find({"age":22},{course:{$slice:2}}).pretty()

查询年纪22，取课程后两门的信息
db.testcoll.find({"age":22},{course:{$slice:-2}}).pretty()

查询年纪22，课程跳过第一个显示后两门的信息
db.testcoll.find({"age":22},{course:{$slice:[1,2]}}).pretty()

数组的操作非常重要，大家要好好掌握并灵活运用。