blocks|key|1406568|text|在MongoDB客户端中，键入：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1406569|db.Collection.updateMany({},+$set:+{field1:+'field1',+field2:+'field2'})|code-block|syntax|javascript|1406570|3.2版中的新功能|1406571|参数：：|1406572|{}:++select+all+records+updated|1406573|未采用关键字参数multi|offset|length|style|CODE|1406574|entityMap^0|0|0|0|0|0|8|5|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|Z|8|@$O|10|P|11|Q|R]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

In the MongoDB Client, type: 

<pre><code>db.Collection.updateMany({}, $set: {field1: 'field1', field2: 'field2'})
</code></pre>

New in version 3.2

Params::

<pre><code>{}: select all records updated
</code></pre>

Keyword argument <code>multi</code> not taken

blocks|key|1191058|text|当您发出update命令时，MongoDB将只找到一个符合查询条件的匹配文档，首先匹配的文档将被更新，即使有更多匹配条件的文档将被忽略。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1191059|因此，为了克服这个问题，我们可以在update语句中指定"MULTI“选项，这意味着更新所有符合查询条件的文档。扫描集合中的所有文档，查找符合条件的文档并进行更新：|1191060|db.test.update({"foo":"bar"},{"$set":{"test":"success!"}},+{multi:true}+)|code-block|syntax|javascript|1191061|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

MongoDB will find only one matching document which matches the query criteria when you are issuing an update command, whichever document matches first happens to be get updated, even if there are more documents which matches the criteria will get ignored.

so to overcome this we can specify "MULTI" option in your update statement, meaning update all those documnets which matches the query criteria. scan for all the documnets in collection finding those which matches the criteria and update :

<pre><code>db.test.update({"foo":"bar"},{"$set":{"test":"success!"}}, {multi:true} )
</code></pre>

blocks|key|1406583|text|以下命令可以更新集合的多条记录|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1406584|db.collection.update({},+
{$set:{"field"+:+"value"}},+
{+multi:+true,+upsert:+false}
)|code-block|syntax|javascript|1406585|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The following command can update multiple records of a collection

<pre><code>db.collection.update({}, 
{$set:{"field" : "value"}}, 
{ multi: true, upsert: false}
)
</code></pre>

blocks|key|1191244|text|要更新整个集合，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1191245|db.getCollection('collection_name').update({},
{$set:+{"field1"+:+"value1",+"field2"+:+"value2",+"field3"+:+"value3"}},
{multi:+true+})|code-block|syntax|javascript|1191246|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To Update Entire Collection,

<pre><code>db.getCollection('collection_name').update({},
{$set: {"field1" : "value1", "field2" : "value2", "field3" : "value3"}},
{multi: true })
</code></pre>

blocks|key|1190987|text|我也遇到了同样的问题，我找到了解决方案，而且效果很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1190988|只需将标志multi设置为true，如下所示：|1190989|+db.Collection.update(
++++++++++++++++{_id_receiver:+id_receiver},
+++++++++++++++{$set:+{is_showed:+true}},
++++++++++++++++{multi:+true}+++/*+-->+multiple+update+*/
++++++++++++,+function+(err,+updated)+{...});|code-block|syntax|javascript|1190990|我希望这能有所帮助:)|1190991|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I had the same problem , and i found the solution , and it works like a charm

just set the flag multi to true like this :

<pre><code> db.Collection.update(
 {_id_receiver: id_receiver},
 {$set: {is_showed: true}},
 {multi: true} /* --&gt; multiple update */
 , function (err, updated) {...});
</code></pre>

i hope that helps :)

blocks|key|1191260|text|updateMany()方法具有以下形式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1191261|db.collection.updateMany(
+++<filter>,
+++<update>,
+++{
+++++upsert:+<boolean>,
+++++writeConcern:+<document>,
+++++collation:+<document>,
+++++arrayFilters:+[+<filterdocument1>,+...+],
+++++hint:++<document%7Cstring>++++++++//+Available+starting+in+MongoDB+4.2.1
+++}
)|code-block|syntax|javascript|1191262|餐厅集合包含以下文档：|1191263|{+"_id"+:+1,+"name"+:+"Central+Perk+Cafe",+"violations"+:+3+}
{+"_id"+:+2,+"name"+:+"Rock+A+Feller+Bar+and+Grill",+"violations"+:+2+}
{+"_id"+:+3,+"name"+:+"Empire+State+Sub",+"violations"+:+5+}
{+"_id"+:+4,+"name"+:+"Pizza+Rat's+Pizzaria",+"violations"+:+8+}|1191264|以下操作将更新所有违规行为大于4的文档，并$set一个标记以供审查：|1191265|try+{
+++db.restaurant.updateMany(
++++++{+violations:+{+$gt:+4+}+},
++++++{+$set:+{+"Review"+:+true+}+}
+++);
}+catch+(e)+{
+++print(e);
}|1191266|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

The updateMany() method has the following form:
<pre><code>db.collection.updateMany(
 &lt;filter&gt;,
 &lt;update&gt;,
 {
 upsert: &lt;boolean&gt;,
 writeConcern: &lt;document&gt;,
 collation: &lt;document&gt;,
 arrayFilters: [ &lt;filterdocument1&gt;, ... ],
 hint: &lt;document|string&gt; // Available starting in MongoDB 4.2.1
 }
)
</code></pre>
The restaurant collection contains the following documents:
<pre><code>{ &quot;_id&quot; : 1, &quot;name&quot; : &quot;Central Perk Cafe&quot;, &quot;violations&quot; : 3 }
{ &quot;_id&quot; : 2, &quot;name&quot; : &quot;Rock A Feller Bar and Grill&quot;, &quot;violations&quot; : 2 }
{ &quot;_id&quot; : 3, &quot;name&quot; : &quot;Empire State Sub&quot;, &quot;violations&quot; : 5 }
{ &quot;_id&quot; : 4, &quot;name&quot; : &quot;Pizza Rat's Pizzaria&quot;, &quot;violations&quot; : 8 }
</code></pre>
The following operation updates all documents where violations are greater than 4 and $set a flag for review:
<pre><code>try {
 db.restaurant.updateMany(
 { violations: { $gt: 4 } },
 { $set: { &quot;Review&quot; : true } }
 );
} catch (e) {
 print(e);
}
</code></pre>

blocks|key|1406501|text|您可以使用.`|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1406502|++++++++Model.update({
++++++++++++'type':+"newuser"
++++++++},+{
++++++++++++$set:+{
++++++++++++++++email:+"abc@gmail.com",
++++++++++++++++phoneNumber:"0123456789"
++++++++++++}
++++++++},+{
++++++++++++multi:+true
++++++++},
++++++++function(err,+result)+{
++++++++++++console.log(result);
++++++++++++console.log(err);
++++++++})++`|code-block|syntax|javascript|1406503|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use.` 

<pre><code> Model.update({
 'type': "newuser"
 }, {
 $set: {
 email: "abc@gmail.com",
 phoneNumber:"0123456789"
 }
 }, {
 multi: true
 },
 function(err, result) {
 console.log(result);
 console.log(err);
 }) `
</code></pre>

blocks|key|1406320|text|感谢分享这篇文章，我使用了2.6.7，下面的查询很好用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1406321|对于所有文档：|1406322|db.screen.update({stat:"PRO"}+,+{$set+:+{stat:"pro"}},+{multi:true})|code-block|syntax|javascript|1406323|对于单个文档：|1406324|db.screen.update({stat:"PRO"}+,+{$set+:+{stat:"pro"}},+{multi:false})|1406325|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Thanks for sharing this, I used with 2.6.7 and following query just worked, 

for all docs: 

<pre><code>db.screen.update({stat:"PRO"} , {$set : {stat:"pro"}}, {multi:true})
</code></pre>

for single doc:

<pre><code>db.screen.update({stat:"PRO"} , {$set : {stat:"pro"}}, {multi:false})
</code></pre>

I was surprised to find that the following example code only updates a single document:

<pre><code>&gt; db.test.save({"_id":1, "foo":"bar"});
&gt; db.test.save({"_id":2, "foo":"bar"});

&gt; db.test.update({"foo":"bar"}, {"$set":{"test":"success!"}});

&gt; db.test.find({"test":"success!"}).count();
1
</code></pre>

I know I can loop through and keep updating until they're all changed, but that seems terribly inefficient. Is there a better way?

MongoDB: How to update multiple documents with a single command?

我很惊讶地发现下面的示例代码只更新了一个文档：> db.test.save({"_id":1, "foo":"bar"});> db.test.save({"_id":2, "foo":"bar"});> db.test.update({"foo":"bar"}, {"$set":{"test":"success!"}});> db.test.find({"test":"success!"}).c

问MongoDB:如何使用一条命令更新多个文档？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB:如何使用一条命令更新多个文档？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB:如何使用一条命令更新多个文档？
EN