Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies如何在 MongoDB 中合并文档数组？
要进行合并，请使用 aggregate() 以及 $PUSH。我们用文档创建一个集合 −
> db.demo64.insertOne({"Subjects":["MySQL","MongoDB","Java"]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e28762bcfb11e5c34d89936")
}
> db.demo64.insertOne({"Subjects":["Oracle","Spring","Python"]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e28763fcfb11e5c34d89937")
}通过 find() 方法显示集合中的所有文档 −
> db.demo64.find();
这会生成以下输出 −
{ "_id" : ObjectId("5e28762bcfb11e5c34d89936"), "Subjects" : [ "MySQL", "MongoDB", "Java" ] }
{ "_id" : ObjectId("5e28763fcfb11e5c34d89937"), "Subjects" : [ "Oracle", "Spring", "Python" ] }以下是 MongoDB 中合并文档数组的查询 −
> db.demo64.aggregate([
... { "$group": {
... "_id": null,
... "Subjects": { "$push": "$Subjects" }
... }},
... { "$project": { "_id": 0 }}
... ]);这会生成以下输出 −
{ "Subjects" : [ [ "MySQL", "MongoDB", "Java" ], [ "Oracle", "Spring", "Python" ] ] }
更新于：2020 年 3 月 30 日
798 次浏览
广告