MacOS10.14.4
brew tap mongodb/brew
brew install mongodb-community@4.0
in the foreground
mongod --config /usr/local/etc/mongod.conf
as a macOS service
brew services start mongodb-community@4.0
ps aux | grep -v grep | grep mongod
You can also view the log file to see the current status of your mongod process:
/usr/local/var/log/mongodb/mongo.log
the configuration file (/usr/local/etc/mongod.conf)
the log directory path (/usr/local/var/log/mongodb)
the data directory path (/usr/local/var/mongodb)
mongo
查看版本
./mongo --version
查看所有数据库
show dbs
查看当前数据库
db
切换数据库
use dbname
查看所有集合
show collections
插入一个
db.inventory.insertOne(
{ item: "canvas", qty: 100, tags: ["cotton"], size: { h: 28, w: 35.5, uom: "cm" } }
)
插入多个
db.inventory.insertMany([
{ item: "journal", qty: 25, tags: ["blank", "red"], size: { h: 14, w: 21, uom: "cm" } },
{ item: "mat", qty: 85, tags: ["gray"], size: { h: 27.9, w: 35.5, uom: "cm" } },
{ item: "mousepad", qty: 25, tags: ["gel", "blue"], size: { h: 19, w: 22.85, uom: "cm" } }
])
查询单个
db.inventory.find( { item: "canvas" } )
查询所有
db.inventory.find( {} )
利用操作符指定查询条件
db.inventory.find( { status: { $in: [ "A", "D" ] } } )
含义等价于
SELECT * FROM inventory WHERE status in ("A", "D")
AND
db.inventory.find( { status: "A", qty: { $lt: 30 } } )
含义等价于
SELECT * FROM inventory WHERE status = "A" AND qty < 30
OR
db.inventory.find( { $or: [ { status: "A" }, { qty: { $lt: 30 } } ] } )
含义等价于
SELECT * FROM inventory WHERE status = "A" OR qty < 30
AND OR
db.inventory.find( {
status: "A",
$or: [ { qty: { $lt: 30 } }, { item: /^p/ } ]
} )
含义等价于
SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%")
update one
db.inventory.updateOne(
{ item: "paper" },
{
$set: { "size.uom": "cm", status: "P" },
$currentDate: { lastModified: true }
}
)
update many
db.inventory.updateMany(
{ "qty": { $lt: 50 } },
{
$set: { "size.uom": "in", status: "P" },
$currentDate: { lastModified: true }
}
)
replace one
db.inventory.replaceOne(
{ item: "paper" },
{ item: "paper", instock: [ { warehouse: "A", qty: 60 }, { warehouse: "B", qty: 40 } ] }
)
嵌套查询例子
{a:"",b:"",c:{d:"",e:{f:""}}}}
e作为查询条件查询
find({c.e.f:""})
delete all
db.inventory.deleteMany({})
delete many
db.inventory.deleteMany({ status : "A" })
delete one
db.inventory.deleteOne( { status: "D" } )
[1]
Install MongoDB Community Edition on macOS: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-os-x/
[2]
insert-documents: https://docs.mongodb.com/manual/tutorial/insert-documents/
[3]
query-documents: https://docs.mongodb.com/manual/tutorial/query-documents/
[4]
update-documents: https://docs.mongodb.com/manual/tutorial/update-documents/
[5]
remove-documents: https://docs.mongodb.com/manual/tutorial/remove-documents/
[6]
MongoDB数据库命令行操作: https://blog.csdn.net/qq_33036599/article/details/83061446
[7]
题图: https://unsplash.com/