MongoDB的簡單使用-查詢操作

來源:互聯網
上載者:User

標籤:ack   最大   pre   object   rac   media   find   author   ini   

MongoDB通過find()函數執行查詢操作

1.尋找集合內的全部文檔:

db.media.find()

系統返回:

{ "_id" : ObjectId("5aa47c1953350e04ddbd6fa3"), "Type" : "Book", "Title" : "Definitive Guide to MongoDB 3rd ed.", "ISBN" : "978-1-4842-1183-0", "Publisher" : "Apress", "Author" : [ "Hows,David", "Plugge,Eelco", "Membrey,Peter", "Hawkins,Tim" ] }
{ "_id" : ObjectId("5aa47dd553350e04ddbd6fa4"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [ { "Track" : "1", "Titie" : "Smells Like Teen Spirit", "Length" : "5:02" }, { "Track" : "2", "Title" : "In Bloom", "Length" : "4:15" } ] }

顯示出上篇文章我們添加的2個文檔

2.尋找Nirvana的所有CD:

db.media.find({Artist:"Nirvana"})

系統返回:

{ "_id" : ObjectId("5aa47dd553350e04ddbd6fa4"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [ { "Track" : "1", "Titie" : "Smells Like Teen Spirit", "Length" : "5:02" }, { "Track" : "2", "Title" : "In Bloom", "Length" : "4:15" } ] }

3.尋找Nirvana的所有CD的標題:

db.media.find({Artist:"Nirvana"},{Title:1})

系統返回:

{ "_id" : ObjectId("5aa47dd553350e04ddbd6fa4"), "Title" : "Nevermind" }

尋找Nirvana的所有CD的非標題資訊

db.media.find({Artist:"Nirvana"},{Title:0})

系統返回:

{ "_id" : ObjectId("5aa47dd553350e04ddbd6fa4"), "Type" : "CD", "Artist" : "Nirvana", "Tracklist" : [ { "Track" : "1", "Titie" : "Smells Like Teen Spirit", "Length" : "5:02" }, { "Track" : "2", "Title" : "In Bloom", "Length" : "4:15" } ] }

4.尋找內嵌對象文檔的資訊:

db.media.find({"Tracklist.Title":"In Bloom"})

系統將返回對應文檔的全部資訊

{ "_id" : ObjectId("5aa47dd553350e04ddbd6fa4"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [ { "Track" : "1", "Titie" : "Smells Like Teen Spirit", "Length" : "5:02" }, { "Track" : "2", "Title" : "In Bloom", "Length" : "4:15" } ] }

5其他相關函數

  sort()排序函數 db.media.find().sort({Title:1})      #1為升序,-1為降序

  limit()限制返回結果的最大數目 db.media.find().limit(10)      #0表示返回所有結果

  skip()忽略集合中的前幾個文檔 db.media.find().skip(20)      

MongoDB的簡單使用-查詢操作

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.