1.进入mongodb安装目录(>cd D:\workPrograms\mongodb\bin)
2.>mongodb 启动mongo db
3.>show dbs; 查询所有数据库
4.>use test; 选择要查询的数据库,此处若test数据库不存在会自动创建test数据库
5.在users collection中插入6条用户数据
>db.users.insertMany(
[ { _id: 1, name: "sue", age: 19, type: 1, status: "P", favorites: { artist: "Picasso", food: "pizza" }, finished: [ 17, 3 ], badges: [ "blue", "black" ], points: [ { points: 85, bonus: 20 }, { points: 85, bonus: 10 } ] }, { _id: 2, name: "bob", age: 42, type: 1, status: "A", favorites: { artist: "Miro", food: "meringue" }, finished: [ 11, 25 ], badges: [ "green" ], points: [ { points: 85, bonus: 20 }, { points: 64, bonus: 12 } ] }, { _id: 3, name: "ahn", age: 22, type: 2, status: "A", favorites: { artist: "Cassatt", food: "cake" }, finished: [ 6 ], badges: [ "blue", "red" ], points: [ { points: 81, bonus: 8 }, { points: 55, bonus: 20 } ] }, { _id: 4, name: "xi", age: 34, type: 2, status: "D", favorites: { artist: "Chagall", food: "chocolate" }, finished: [ 5, 11 ], badges: [ "red", "black" ], points: [ { points: 53, bonus: 15 }, { points: 51, bonus: 15 } ] }, { _id: 5, name: "xyz", age: 23, type: 2, status: "D", favorites: { artist: "Noguchi", food: "nougat" }, finished: [ 14, 6 ], badges: [ "orange" ], points: [ { points: 71, bonus: 20 } ] }, { _id: 6, name: "abc", age: 43, type: 1, status: "A", favorites: { food: "pizza", artist: "Picasso" }, finished: [ 18, 12 ], badges: [ "black", "blue" ], points: [ { points: 78, bonus: 8 }, { points: 57, bonus: 7 } ] } ] )
6.>db.users.find(); 查询users里的所有数据
7.>db.users.find({status: 'A'}); 查询users里status等于A的数据
8.>db.users.find({age:{$gt:22}}); 查询users里年龄大于22的数据
9.> db.users.find({status: 'D', age: {$gt: 23}}); 查询users里状态为D并且年龄大于23的数据
10.>db.users.find({$or: [{status: 'A'}, {age: {$gt: 23}}]}); 查询users里状态为A或者年龄大于23的数据
11.>db.users.find( { favorites: { artist: "Picasso", food: "pizza" } } ); 嵌套查询,匹配整个子文档,查询favorites里artist为Picasso,food为pizza的用户
12.>db.users.find( { "favorites.artist": "Picasso" } ); 嵌套查询,匹配子文档中的字段,通过点(.)符号来表示子文档中的字段
13.>db.users.find( { badges: [ "blue", "black" ] } ); 数组查询,匹配所有数组,查找badges的值为"['blue', 'black']"的用户
14.>db.users.find( { badges: "black" } ); 数组查询,查询数组中的一个元素,查找badges的数组中包含了'black'元素的所有用户
15.> db.users.find( { finished: { $elemMatch: { $gt: 15, $lt: 20 } } } ); 数组多条件and查询($elemMatch),$elemMatch多个条件and匹配,假设我们要找到满足finished字段中的数组元素的值大于15并且小于20
结果:{ "_id" : 1, ..., "finished" : [ 17, 3 ] ,...}
{ "_id" : 6, ..., "finished" : [ 18, 12 ], ...}
16.>db.users.find( { finished: { $gt: 15, $lt: 20 } } ); 数组多条件or查询,查询大于15或者小于20的数据
结果:{ "_id" : 1,..., "finished" : [ 17, 3 ], ...}
{ "_id" : 2, ..., "finished" : [ 11, 25 ], ...}
{ "_id" : 6, ..., "finished" : [ 18, 12 ], ...}
17.>db.users.find( { 'points.0.points': { $lte: 55 } } ); 使用数组下标定位集合子文档,查询数组中第一个points的值,小于等于55的数据
18.>db.users.find( { 'points.points': { $lte: 55 } } ); 省略下标,查询points数组中所有的points的值小于等于55的数据
19.> db.users.find( { points: { $elemMatch: { points: { $lte: 70 }, bonus: 20 } } } ); 多条件and查询($elemMatch),查询points数组中points的值小于等于70并且bonus为20的数据
结果:{ "_id" : 3, ....,"points" : [ { "points" : 81, "bonus" : 8 }, { "points" : 55, "bonus" : 20 } ] }
20.>db.users.find({"points.points": {$lte: 70}, "points.bonus": 20}); 多条件or查询, 查询points数组中,points的值小于等于70或者bonus为20的数据
结果:{ "_id" : 2, ..., "points" : [ { "points" : 85, "bonus" : 20 }, { "points" : 64, "bonus" : 12 } ] }
{ "_id" : 3, ..., "points" : [ { "points" : 81, "bonus" : 8 }, { "points" : 55, "bonus" : 20 } ] }
参考资料地址:https://www.linuxidc.com/Linux/2016-10/136581.htm