|
mongo
|
Start Mongo
|
|
show dbs
|
Show databases
|
|
use mydb
|
User database named "mydb"
|
|
db
|
Show selected database
|
|
help
|
Get help
|
|
show collections
|
Show collections from a database
|
|
.find()
|
Displays documents from "collection" (first 10)
|
|
it
|
Type "it" to see more documents after the prev command
|
|
.find(query[,fields])
|
Find all documents by conditions, with optional fields selection
|
|
.findOne(query)
|
Find one document by conditions
|
|
.find(query).limit(n:number)
|
Find n document by conditions
|
|
.find().pretty()
|
Format results in Mongo Shell
|
|
.find().sort(key:1|-1)
|
Sort by key in ascending (1) or descending (-1) order
|
|
.find().skip(5)
|
Skip 5 documents (similar to offset)
|
|
.insert(document(s) [,options])
|
Insert a new document or multiple documents(if provided an array of documents) in the collection. Options: writeConcern, ordered
|
|
.insertOne(document, [,options])
|
Same as insert from 3.2
|
|
.insertMany(array of documents, [,options])
|
Same as in sert from 3.2
|
|
.update(query, update [,options])
|
Update the documents matched by the query. See update operators. Options: upsert(insert if no match), multi(aply to multiple elements), writeConcern
|
|
.remove(query [,options])
|
Remote some documents from a collection. {} for all. options: {justOne, writeConcern}
|
|
.deleteOne(query), deleteMany(query)
|
Similar to remove
|
|
_id
|
Search by ID
|
|
key: value
|
Search through key-value combination
|
|
{ subkey: value }
|
Search with subdocument
|
|
$in : [ e1, e2, .. ]
|
Search IN Array
|
|
$exists:Boolean
|
Check if property exists or not
|
|
$mod:[D,R]
|
Checks if a property divided by D has the specified R
|
|
$type:Int
|
Checks if property is the specified type
|
|
$gt:Val
|
Greater then Val
|
|
$gte:Val
|
Greater then equals Val
|
|
$lt:Val
|
Lower then Val
|
|
$lte:Val
|
Lower then equals Val
|
|
$all:Array
|
All Array elements are included in field array value
|
|
$in:Array
|
Elements with values contained in Array
|
|
$nin:Array
|
Elements with values Not contained in Array
|
|
$ne:Val
|
Not equal
|
|
$and:AOE
|
AND operation between all AOE expressions
|
|
$nor:AOE
|
all AOE expressions must fail
|
|
$not:Expr
|
Negate a SubDocument (doesn't work with $regex)
|
|
$or:AOE
|
OR operation between all AOE expressions
|
Hello, could you update this cheatsheet with insert, update and remove operations?
Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.
