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 次瀏覽
廣告