資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會學
服裝研究
法律研究如何在 MongoDB 中連線欄位？
要連線欄位，請使用 $concat 運算子。我們首先使用文件建立集合 −
>db.concatenateFieldsDemo.insertOne({"StudentFirstName":"Adam","StudentLastName":"Smith"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ebf46d78f205348bc62e")
}
>db.concatenateFieldsDemo.insertOne({"StudentFirstName":"John","StudentLastName":"Doe"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ebfc6d78f205348bc62f")
}
>db.concatenateFieldsDemo.insertOne({"StudentFirstName":"David","StudentLastName":"Miller"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ec376d78f205348bc630")
}
>db.concatenateFieldsDemo.insertOne({"StudentFirstName":"Sam","StudentLastName":"Williams"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd6ec436d78f205348bc631")
}以下是使用 find() 方法從集合顯示所有文件的查詢 −
> db.concatenateFieldsDemo.find().pretty();
這將生成以下輸出 −
{
"_id" : ObjectId("5cd6ebf46d78f205348bc62e"),
"StudentFirstName" : "Adam",
"StudentLastName" : "Smith"
}
{
"_id" : ObjectId("5cd6ebfc6d78f205348bc62f"),
"StudentFirstName" : "John",
"StudentLastName" : "Doe"
}
{
"_id" : ObjectId("5cd6ec376d78f205348bc630"),
"StudentFirstName" : "David",
"StudentLastName" : "Miller"
}
{
"_id" : ObjectId("5cd6ec436d78f205348bc631"),
"StudentFirstName" : "Sam",
"StudentLastName" : "Williams"
}以下是選擇和連線欄位的查詢 −
> db.concatenateFieldsDemo.aggregate([
{$project:{"StudentFullName":{$concat:
["$StudentFirstName","/","$StudentLastName"]},"StudentFirstName":1,"StudentLastName":1}}
]);這將生成以下輸出 −
{ "_id" : ObjectId("5cd6ebf46d78f205348bc62e"), "StudentFirstName" : "Adam", "StudentLastName" : "Smith", "StudentFullName" : "Adam/Smith" }
{ "_id" : ObjectId("5cd6ebfc6d78f205348bc62f"), "StudentFirstName" : "John", "StudentLastName" : "Doe", "StudentFullName" : "John/Doe" }
{ "_id" : ObjectId("5cd6ec376d78f205348bc630"), "StudentFirstName" : "David", "StudentLastName" : "Miller", "StudentFullName" : "David/Miller" }
{ "_id" : ObjectId("5cd6ec436d78f205348bc631"), "StudentFirstName" : "Sam", "StudentLastName" : "Williams", "StudentFullName" : "Sam/Williams" }
更新於: 30-7-2019
289 次瀏覽量
廣告