数据结构
网络
RDBMS
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理学
化学
生物学
数学
英语
经济学
心理学
社会学
时尚研究
法律研究在一个 MongoDB 查询中更新多行记录？
使用 initializeUnorderedBulkOp() 的概念。我们首先创建一个带文档的集合 −
>db.upDateMultipleRowsDemo.insertOne({"CustomerName":"John","CustomerPurchaseAmount":500});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ceb06d78f205348bc626")
}
>db.upDateMultipleRowsDemo.insertOne({"CustomerName":"Chris","CustomerPurchaseAmount":700});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ceb26d78f205348bc627")
}
>db.upDateMultipleRowsDemo.insertOne({"CustomerName":"David","CustomerPurchaseAmount":50});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ceb36d78f205348bc628")
}
>db.upDateMultipleRowsDemo.insertOne({"CustomerName":"Larry","CustomerPurchaseAmount":1900});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ceb46d78f205348bc629")
}以下是使用 find() 方法显示集合中所有文档的查询 −
> db.upDateMultipleRowsDemo.find().pretty();
这将产生以下输出 −
{
"_id" : ObjectId("5cd6ceb06d78f205348bc626"),
"CustomerName" : "John",
"CustomerPurchaseAmount" : 500
}
{
"_id" : ObjectId("5cd6ceb26d78f205348bc627"),
"CustomerName" : "Chris",
"CustomerPurchaseAmount" : 700
}
{
"_id" : ObjectId("5cd6ceb36d78f205348bc628"),
"CustomerName" : "David",
"CustomerPurchaseAmount" : 50
}
{
"_id" : ObjectId("5cd6ceb46d78f205348bc629"),
"CustomerName" : "Larry",
"CustomerPurchaseAmount" : 1900
}以下是进行一次查询更新多行记录的查询 −
> var manyUpdateValue = db.upDateMultipleRowsDemo.initializeUnorderedBulkOp();
> manyUpdateValue.find({ _id: ObjectId("5cd6ceb06d78f205348bc626")}).updateOne({$set:{"CustomerName":"Bob" }});
> manyUpdateValue.find({ _id: ObjectId("5cd6ceb36d78f205348bc628")}).updateOne({$set:{"CustomerPurchaseAmount":56544444}});
> manyUpdateValue.execute();
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 0,
"nUpserted" : 0,
"nMatched" : 2,
"nModified" : 2,
"nRemoved" : 0,
"upserted" : [ ]
})让我们再次检查所有文档 −
> db.upDateMultipleRowsDemo.find().pretty();
这将产生以下输出 −
{
"_id" : ObjectId("5cd6ceb06d78f205348bc626"),
"CustomerName" : "Bob",
"CustomerPurchaseAmount" : 500
}
{
"_id" : ObjectId("5cd6ceb26d78f205348bc627"),
"CustomerName" : "Chris",
"CustomerPurchaseAmount" : 700
}
{
"_id" : ObjectId("5cd6ceb36d78f205348bc628"),
"CustomerName" : "David",
"CustomerPurchaseAmount" : 56544444
}
{
"_id" : ObjectId("5cd6ceb46d78f205348bc629"),
"CustomerName" : "Larry",
"CustomerPurchaseAmount" : 1900
}
更新于： 30-Jul-2019
341 查看数
广告