Mongodb: Difference between revisions

From Bitpost wiki
No edit summary
Line 20: Line 20:
* To remove all documents that do not have a range of values:
* To remove all documents that do not have a range of values:
  db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )
  db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )
==== Run a script or statement from command line ====
# This will drop the bookstore db
mongo bookstore --eval "printjson(db.dropDatabase())"

Revision as of 19:30, 28 January 2020

Installation

UI tools =

  • MongoDB_Admin
git clone https://github.com/hatamiarash7/MongoDB_Admin
cd MongoDB_Admin
npm start &
  • Robo 3T
~/apps/robo3t/bin/robo3t &

Querying

  • OR
{"$or": [{"firstName": "Michael"}, {"firstName": "Tom"}]}
  • To remove all documents that do not have a certain value:
db.inventory.remove( { type : { $ne: "food" } } )
  • To remove all documents that do not have a range of values:
db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )

Run a script or statement from command line

# This will drop the bookstore db
mongo bookstore --eval "printjson(db.dropDatabase())"