Basic Mongo DB
db
|
Show name of current database
|
mongod
|
Start database
|
mongo
|
Connect to database
|
show dbs
|
Show databases
|
use db
|
Switch to database db
|
show collections
|
Display current database collections
|
Create
insert(data)
|
insert document(s) returns write result
|
insertOne (data, options)
|
insert one document
|
insertMany(data, options)
|
insert many documents
|
insertMany([{},{},{}])
|
needs square brackets
|
Read
db.collection.find()
|
Display documents from collection
|
find(filter, options)
|
find all matching documents
|
findOne(filter, options)
|
find first matching document
|
Update
updateOne(filter, data, options)
|
Change one document
|
updateMany(filter, data, options)
|
Change many documents
|
replaceOne(filter, data, options)
|
Replace document entirely
|
Delete
deleteOne(filter, options)
|
Delete one document
|
deleteMany(filter, options)
|
Delete many documents
|
Filters
{"key": "value"}
|
Used for filter arguments to filter collection
|
{key: {$operator: value} }
|
Operators for querying data
|
{key: {$exists: true}}
|
Matches all documents containing subdocument
key
|
$eq
|
Matches values that are equal to a specified value.
|
$gt
|
Matches values that are greater than a specified value.
|
$gte
|
Matches values that are greater than or equal to a
specified value.
|
$in
|
Matches any of the values specified in an array
|
syntax:
|
{key:{$in: [array of values] } }
|
$lt
|
Matches values that are less than a specified value.
|
$lte
|
Matches values that are less than or equal to a specified
value.
|
$ne
|
Matches all values that are not equal to a specified
value.
|
$nin
|
Matches none of the values specified in an array.
|
$and
|
Performs AND operation
|
syntax:
|
{$and: [ {},{} ] }
|
{key: {$op: filter}, {filter}}
|
$and operator is necessary when the same field or operator
has to be specified in multiple expressions
|
find({doc.subdoc:value})
|
Filter sub documents
|
Functions
.count()
|
Counts how many results
|
.sort(filter)
|
Sort ascend:1 descend: -1
|
|
1 Comments
Excellent work
ReplyDelete