資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理學
化學
生物學
數學
英語
經濟學
心理學
社會學
時尚設計
法律研究如何在 MongoDB 資料庫中獲取 SELECT column1, column2 FROM tbl 的等效項？
等效語法如下。
db.yourCollectionName.find({}, {_id: 1, "column1": 1, "column2": 1}).pretty();為了理解上述語法，我們建立一個包含文件的集合。建立包含文件的集合的查詢如下所示 -
> db.equivalentForSelectColumn1Column2Demo.insertOne({"CustomerName":"John","CustomerAge":26,"CustomerCountryName":"US"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c92c6205259fcd19549980a")
}
> db.equivalentForSelectColumn1Column2Demo.insertOne({"CustomerName":"David","CustomerAge":22,"CustomerCountryName":"AUS"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c92c6305259fcd19549980b")
}
> db.equivalentForSelectColumn1Column2Demo.insertOne({"CustomerName":"Chris","CustomerAge":24,"CustomerCountryName":"UK"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c92c6415259fcd19549980c")
}使用 find() 方法顯示集合中的所有文件。查詢如下所示 -
> db.equivalentForSelectColumn1Column2Demo.find().pretty();
輸出如下 -
{
"_id" : ObjectId("5c92c6205259fcd19549980a"),
"CustomerName" : "John",
"CustomerAge" : 26,
"CustomerCountryName" : "US"
}
{
"_id" : ObjectId("5c92c6305259fcd19549980b"),
"CustomerName" : "David",
"CustomerAge" : 22,
"CustomerCountryName" : "AUS"
}
{
"_id" : ObjectId("5c92c6415259fcd19549980c"),
"CustomerName" : "Chris",
"CustomerAge" : 24,
"CustomerCountryName" : "UK"
}以下是在 MongoDB 資料庫中 select column1, column2 from tbl 的等效語法 -
> db.equivalentForSelectColumn1Column2Demo.find({}, {"CustomerName": 1, "CustomerAge": 1}).pretty();輸出如下 -
{
"_id" : ObjectId("5c92c6205259fcd19549980a"),
"CustomerName" : "John",
"CustomerAge" : 26
}
{
"_id" : ObjectId("5c92c6305259fcd19549980b"),
"CustomerName" : "David",
"CustomerAge" : 22
}
{
"_id" : ObjectId("5c92c6415259fcd19549980c"),
"CustomerName" : "Chris",
"CustomerAge" : 24
}如果您不想包含 _id，請使用以下查詢 -
> db.equivalentForSelectColumn1Column2Demo.find({}, {_id: 0, "CustomerName": 1, "CustomerAge": 1}).pretty();輸出如下 -
{ "CustomerName" : "John", "CustomerAge" : 26 }
{ "CustomerName" : "David", "CustomerAge" : 22 }
{ "CustomerName" : "Chris", "CustomerAge" : 24 }
更新於: 30-Jul-2019
190 次瀏覽
廣告