mongodb插入数据

发表于 | 分类于

插入数据

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
> use test
switched to db test
> db.students.insertMany(
... [{"name": "测试-0", "age": 63, "sex": "female", "grade": 1},{"name": "测试-1", "age": 32, "sex": "male", "grade": 7},{"name": "测试-2", "age": 20, "sex": "female", "grade": 8},{"name": "测试-3", "age": 55, "sex": "female", "grade": 58},{"name": "测试-4", "age": 84, "sex": "male", "grade": 65},{"name": "测试-5", "age": 27, "sex": "female", "grade": 57},{"name": "测试-6", "age": 86, "sex": "female", "grade": 61},{"name": "测试-7", "age": 18, "sex": "female", "grade": 93},{"name": "测试-8", "age": 50, "sex": "female", "grade": 71},{"name": "测试-9", "age": 81, "sex": "male", "grade": 42},{"name": "测试-10", "age": 26, "sex": "male", "grade": 25},{"name": "测试-11", "age": 91, "sex": "female", "grade": 14},{"name": "测试-12", "age": 6, "sex": "female", "grade": 54},{"name": "测试-13", "age": 73, "sex": "male", "grade": 24},{"name": "测试-14", "age": 51, "sex": "male", "grade": 14},{"name": "测试-15", "age": 53, "sex": "female", "grade": 19},{"name": "测试-16", "age": 3, "sex": "female", "grade": 48},{"name": "测试-17", "age": 13, "sex": "male", "grade": 11},{"name": "测试-18", "age": 40, "sex": "female", "grade": 97},{"name": "测试-19", "age": 97, "sex": "male", "grade": 96}])
{
        "acknowledged" : true,
        "insertedIds" : [
                ObjectId("5de8b35c75deb540ecfc5332"),
                ObjectId("5de8b35c75deb540ecfc5333"),
                ObjectId("5de8b35c75deb540ecfc5334"),
                ObjectId("5de8b35c75deb540ecfc5335"),
                ObjectId("5de8b35c75deb540ecfc5336"),
                ObjectId("5de8b35c75deb540ecfc5337"),
                ObjectId("5de8b35c75deb540ecfc5338"),
                ObjectId("5de8b35c75deb540ecfc5339"),
                ObjectId("5de8b35c75deb540ecfc533a"),
                ObjectId("5de8b35c75deb540ecfc533b"),
                ObjectId("5de8b35c75deb540ecfc533c"),
                ObjectId("5de8b35c75deb540ecfc533d"),
                ObjectId("5de8b35c75deb540ecfc533e"),
                ObjectId("5de8b35c75deb540ecfc533f"),
                ObjectId("5de8b35c75deb540ecfc5340"),
                ObjectId("5de8b35c75deb540ecfc5341"),
                ObjectId("5de8b35c75deb540ecfc5342"),
                ObjectId("5de8b35c75deb540ecfc5343"),
                ObjectId("5de8b35c75deb540ecfc5344"),
                ObjectId("5de8b35c75deb540ecfc5345")
        ]
}
> db.students.find()
{ "_id" : ObjectId("5de8b35c75deb540ecfc5332"), "name" : "测试-0", "age" : 63, "sex" : "female", "grade" : 1 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5333"), "name" : "测试-1", "age" : 32, "sex" : "male", "grade" : 7 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5334"), "name" : "测试-2", "age" : 20, "sex" : "female", "grade" : 8 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5335"), "name" : "测试-3", "age" : 55, "sex" : "female", "grade" : 58 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5336"), "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5337"), "name" : "测试-5", "age" : 27, "sex" : "female", "grade" : 57 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5338"), "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5339"), "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533a"), "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533b"), "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533c"), "name" : "测试-10", "age" : 26, "sex" : "male", "grade" : 25 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533d"), "name" : "测试-11", "age" : 91, "sex" : "female", "grade" : 14 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533e"), "name" : "测试-12", "age" : 6, "sex" : "female", "grade" : 54 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533f"), "name" : "测试-13", "age" : 73, "sex" : "male", "grade" : 24 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5340"), "name" : "测试-14", "age" : 51, "sex" : "male", "grade" : 14 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5341"), "name" : "测试-15", "age" : 53, "sex" : "female", "grade" : 19 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5342"), "name" : "测试-16", "age" : 3, "sex" : "female", "grade" : 48 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5343"), "name" : "测试-17", "age" : 13, "sex" : "male", "grade" : 11 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5344"), "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5345"), "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96 }
> db.students.find({sex:'male'},{age:1,name:1,_id:0})  # sex 为 male false 不显示， true 显示
{ "name" : "测试-1", "age" : 32 }
{ "name" : "测试-4", "age" : 84 }
{ "name" : "测试-9", "age" : 81 }
{ "name" : "测试-10", "age" : 26 }
{ "name" : "测试-13", "age" : 73 }
{ "name" : "测试-14", "age" : 51 }
{ "name" : "测试-17", "age" : 13 }
{ "name" : "测试-19", "age" : 97 }
> db.students.find({grade:{'$gte':60}},{_id:0})  # grade 大于等于 60 
{ "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65 }
{ "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61 }
{ "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71 }
{ "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97 }
{ "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96 }
> db.students.find({'$or':[{sex:'female',age:18},{sex:'male',age:81}]},{_id:0})  # age =18,sex  = famale 或 age = 81,sex  = male
{ "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42 }
> db.students.find().sort({age:-1})  #  按 age 倒序 
{ "_id" : ObjectId("5de8b35c75deb540ecfc5345"), "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533d"), "name" : "测试-11", "age" : 91, "sex" : "female", "grade" : 14 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5338"), "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5336"), "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533b"), "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533f"), "name" : "测试-13", "age" : 73, "sex" : "male", "grade" : 24 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5332"), "name" : "测试-0", "age" : 63, "sex" : "female", "grade" : 1 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5335"), "name" : "测试-3", "age" : 55, "sex" : "female", "grade" : 58 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5341"), "name" : "测试-15", "age" : 53, "sex" : "female", "grade" : 19 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5340"), "name" : "测试-14", "age" : 51, "sex" : "male", "grade" : 14 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533a"), "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5344"), "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5333"), "name" : "测试-1", "age" : 32, "sex" : "male", "grade" : 7 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5337"), "name" : "测试-5", "age" : 27, "sex" : "female", "grade" : 57 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533c"), "name" : "测试-10", "age" : 26, "sex" : "male", "grade" : 25 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5334"), "name" : "测试-2", "age" : 20, "sex" : "female", "grade" : 8 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5339"), "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5343"), "name" : "测试-17", "age" : 13, "sex" : "male", "grade" : 11 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc533e"), "name" : "测试-12", "age" : 6, "sex" : "female", "grade" : 54 }
{ "_id" : ObjectId("5de8b35c75deb540ecfc5342"), "name" : "测试-16", "age" : 3, "sex" : "female", "grade" : 48 }
> db.students.find({},{_id:0}).sort({age:1})  # 查询所有，不显示_id,按age 升序
{ "name" : "测试-16", "age" : 3, "sex" : "female", "grade" : 48 }
{ "name" : "测试-12", "age" : 6, "sex" : "female", "grade" : 54 }
{ "name" : "测试-17", "age" : 13, "sex" : "male", "grade" : 11 }
{ "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "name" : "测试-2", "age" : 20, "sex" : "female", "grade" : 8 }
{ "name" : "测试-10", "age" : 26, "sex" : "male", "grade" : 25 }
{ "name" : "测试-5", "age" : 27, "sex" : "female", "grade" : 57 }
{ "name" : "测试-1", "age" : 32, "sex" : "male", "grade" : 7 }
{ "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97 }
{ "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71 }
{ "name" : "测试-14", "age" : 51, "sex" : "male", "grade" : 14 }
{ "name" : "测试-15", "age" : 53, "sex" : "female", "grade" : 19 }
{ "name" : "测试-3", "age" : 55, "sex" : "female", "grade" : 58 }
{ "name" : "测试-0", "age" : 63, "sex" : "female", "grade" : 1 }
{ "name" : "测试-13", "age" : 73, "sex" : "male", "grade" : 24 }
{ "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42 }
{ "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65 }
{ "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61 }
{ "name" : "测试-11", "age" : 91, "sex" : "female", "grade" : 14 }
{ "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96 }
> db.students.update({},{'$set':{class:'class 1'}})  # 仅修改第一条数据
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.students.find({},{_id:0})
{ "name" : "测试-0", "age" : 63, "sex" : "female", "grade" : 1, "class" : "class 1" }
{ "name" : "测试-1", "age" : 32, "sex" : "male", "grade" : 7 }
{ "name" : "测试-2", "age" : 20, "sex" : "female", "grade" : 8 }
{ "name" : "测试-3", "age" : 55, "sex" : "female", "grade" : 58 }
{ "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65 }
{ "name" : "测试-5", "age" : 27, "sex" : "female", "grade" : 57 }
{ "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61 }
{ "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93 }
{ "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71 }
{ "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42 }
{ "name" : "测试-10", "age" : 26, "sex" : "male", "grade" : 25 }
{ "name" : "测试-11", "age" : 91, "sex" : "female", "grade" : 14 }
{ "name" : "测试-12", "age" : 6, "sex" : "female", "grade" : 54 }
{ "name" : "测试-13", "age" : 73, "sex" : "male", "grade" : 24 }
{ "name" : "测试-14", "age" : 51, "sex" : "male", "grade" : 14 }
{ "name" : "测试-15", "age" : 53, "sex" : "female", "grade" : 19 }
{ "name" : "测试-16", "age" : 3, "sex" : "female", "grade" : 48 }
{ "name" : "测试-17", "age" : 13, "sex" : "male", "grade" : 11 }
{ "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97 }
{ "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96 }
> db.students.update({},{'$set':{class:'class 2'}},{multi:true}) # {multi:true} 多条属性
WriteResult({ "nMatched" : 20, "nUpserted" : 0, "nModified" : 19 })
> db.students.find({},{_id:0})
{ "name" : "测试-0", "age" : 63, "sex" : "female", "grade" : 1, "class" : "class 2" }
{ "name" : "测试-1", "age" : 32, "sex" : "male", "grade" : 7, "class" : "class 2" }
{ "name" : "测试-2", "age" : 20, "sex" : "female", "grade" : 8, "class" : "class 2" }
{ "name" : "测试-3", "age" : 55, "sex" : "female", "grade" : 58, "class" : "class 2" }
{ "name" : "测试-4", "age" : 84, "sex" : "male", "grade" : 65, "class" : "class 2" }
{ "name" : "测试-5", "age" : 27, "sex" : "female", "grade" : 57, "class" : "class 2" }
{ "name" : "测试-6", "age" : 86, "sex" : "female", "grade" : 61, "class" : "class 2" }
{ "name" : "测试-7", "age" : 18, "sex" : "female", "grade" : 93, "class" : "class 2" }
{ "name" : "测试-8", "age" : 50, "sex" : "female", "grade" : 71, "class" : "class 2" }
{ "name" : "测试-9", "age" : 81, "sex" : "male", "grade" : 42, "class" : "class 2" }
{ "name" : "测试-10", "age" : 26, "sex" : "male", "grade" : 25, "class" : "class 2" }
{ "name" : "测试-11", "age" : 91, "sex" : "female", "grade" : 14, "class" : "class 2" }
{ "name" : "测试-12", "age" : 6, "sex" : "female", "grade" : 54, "class" : "class 2" }
{ "name" : "测试-13", "age" : 73, "sex" : "male", "grade" : 24, "class" : "class 2" }
{ "name" : "测试-14", "age" : 51, "sex" : "male", "grade" : 14, "class" : "class 2" }
{ "name" : "测试-15", "age" : 53, "sex" : "female", "grade" : 19, "class" : "class 2" }
{ "name" : "测试-16", "age" : 3, "sex" : "female", "grade" : 48, "class" : "class 2" }
{ "name" : "测试-17", "age" : 13, "sex" : "male", "grade" : 11, "class" : "class 2" }
{ "name" : "测试-18", "age" : 40, "sex" : "female", "grade" : 97, "class" : "class 2" }
{ "name" : "测试-19", "age" : 97, "sex" : "male", "grade" : 96, "class" : "class 2" }
> db.students.update({},{'$inc':{age:1}},{multi:true})  # 所有人的age加1 
WriteResult({ "nMatched" : 20, "nUpserted" : 0, "nModified" : 20 })
> db.students.find({},{_id:0})  
{ "name" : "测试-0", "age" : 64, "sex" : "female", "grade" : 1, "class" : "class 2" }
{ "name" : "测试-1", "age" : 33, "sex" : "male", "grade" : 7, "class" : "class 2" }
{ "name" : "测试-2", "age" : 21, "sex" : "female", "grade" : 8, "class" : "class 2" }
{ "name" : "测试-3", "age" : 56, "sex" : "female", "grade" : 58, "class" : "class 2" }
{ "name" : "测试-4", "age" : 85, "sex" : "male", "grade" : 65, "class" : "class 2" }
{ "name" : "测试-5", "age" : 28, "sex" : "female", "grade" : 57, "class" : "class 2" }
{ "name" : "测试-6", "age" : 87, "sex" : "female", "grade" : 61, "class" : "class 2" }
{ "name" : "测试-7", "age" : 19, "sex" : "female", "grade" : 93, "class" : "class 2" }
{ "name" : "测试-8", "age" : 51, "sex" : "female", "grade" : 71, "class" : "class 2" }
{ "name" : "测试-9", "age" : 82, "sex" : "male", "grade" : 42, "class" : "class 2" }
{ "name" : "测试-10", "age" : 27, "sex" : "male", "grade" : 25, "class" : "class 2" }
{ "name" : "测试-11", "age" : 92, "sex" : "female", "grade" : 14, "class" : "class 2" }
{ "name" : "测试-12", "age" : 7, "sex" : "female", "grade" : 54, "class" : "class 2" }
{ "name" : "测试-13", "age" : 74, "sex" : "male", "grade" : 24, "class" : "class 2" }
{ "name" : "测试-14", "age" : 52, "sex" : "male", "grade" : 14, "class" : "class 2" }
{ "name" : "测试-15", "age" : 54, "sex" : "female", "grade" : 19, "class" : "class 2" }
{ "name" : "测试-16", "age" : 4, "sex" : "female", "grade" : 48, "class" : "class 2" }
{ "name" : "测试-17", "age" : 14, "sex" : "male", "grade" : 11, "class" : "class 2" }
{ "name" : "测试-18", "age" : 41, "sex" : "female", "grade" : 97, "class" : "class 2" }
{ "name" : "测试-19", "age" : 98, "sex" : "male", "grade" : 96, "class" : "class 2" }
> db.students.update({sex:'male'},{'$inc':{grade:-1}},{multi:true}) # sex:male 的grade 减1 
WriteResult({ "nMatched" : 8, "nUpserted" : 0, "nModified" : 8 })
> db.students.find({},{_id:0})
{ "name" : "测试-0", "age" : 64, "sex" : "female", "grade" : 1, "class" : "class 2" }
{ "name" : "测试-1", "age" : 33, "sex" : "male", "grade" : 6, "class" : "class 2" }
{ "name" : "测试-2", "age" : 21, "sex" : "female", "grade" : 8, "class" : "class 2" }
{ "name" : "测试-3", "age" : 56, "sex" : "female", "grade" : 58, "class" : "class 2" }
{ "name" : "测试-4", "age" : 85, "sex" : "male", "grade" : 64, "class" : "class 2" }
{ "name" : "测试-5", "age" : 28, "sex" : "female", "grade" : 57, "class" : "class 2" }
{ "name" : "测试-6", "age" : 87, "sex" : "female", "grade" : 61, "class" : "class 2" }
{ "name" : "测试-7", "age" : 19, "sex" : "female", "grade" : 93, "class" : "class 2" }
{ "name" : "测试-8", "age" : 51, "sex" : "female", "grade" : 71, "class" : "class 2" }
{ "name" : "测试-9", "age" : 82, "sex" : "male", "grade" : 41, "class" : "class 2" }
{ "name" : "测试-10", "age" : 27, "sex" : "male", "grade" : 24, "class" : "class 2" }
{ "name" : "测试-11", "age" : 92, "sex" : "female", "grade" : 14, "class" : "class 2" }
{ "name" : "测试-12", "age" : 7, "sex" : "female", "grade" : 54, "class" : "class 2" }
{ "name" : "测试-13", "age" : 74, "sex" : "male", "grade" : 23, "class" : "class 2" }
{ "name" : "测试-14", "age" : 52, "sex" : "male", "grade" : 13, "class" : "class 2" }
{ "name" : "测试-15", "age" : 54, "sex" : "female", "grade" : 19, "class" : "class 2" }
{ "name" : "测试-16", "age" : 4, "sex" : "female", "grade" : 48, "class" : "class 2" }
{ "name" : "测试-17", "age" : 14, "sex" : "male", "grade" : 10, "class" : "class 2" }
{ "name" : "测试-18", "age" : 41, "sex" : "female", "grade" : 97, "class" : "class 2" }
{ "name" : "测试-19", "age" : 98, "sex" : "male", "grade" : 95, "class" : "class 2" }