MongoDB simple command

最新推荐文章于 2025-02-28 10:35:02 发布

原创最新推荐文章于 2025-02-28 10:35:02 发布 · 660 阅读

0 ·

CC 4.0 BY-SA版权

DB 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了如何下载并安装MongoDB，启动服务，并通过命令行进行基本操作，包括创建数据库、查询数据、插入更新删除文档等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. download free Mongodb from https://www.mongodb.com/download-center#community, I use windows version

2. install mongodb

3. start mongodb

D:\dev\MongoDB\bin>mongod

4. use command line

D:\dev\MongoDB\bin>mongo

5. list current databases

>show dbs

>show databases

6. create a database named 'lyexnode'

use lyexnode

7. list tables

>show tables

>show collections

8. list users

>show users

9. list roles

>show roles

https://docs.mongodb.com/manual/tutorial/write-scripts-for-the-mongo-shell/#mongo-shell-javascript-file

10. execute users.js file

db = connect("localhost:27017/lyexnode");
cursor = db.users.find();
while ( cursor.hasNext() ) {
printjson( cursor.next() );
}

D:\dev\MongoDB\bin>mongo localhost:27017/lyexnode users.js

D:\dev\MongoDB\bin>mongo users.js

>load("users.js")

11. find data in table/document

a. query, return all of the columns

db.users.findOne({"name":"admin"})

b. query with specified return columns. "_id" is returned by default. It has to be specified as 0 explicitly

db.users.findOne({"name":"admin"},{_id:0, name:1, password:1})

12. insert/update data to document

db.userInfo.insertOne(
   {
      name: "sue",
      age: 26,
      status: "pending"
   }
)

db.userInfo.insert(
   {
      name: "sue",
      age: 26,
      status: "A"
   }
)

db.userInfo.insertMany(
   [
      { name: "sue", age: 26, status: "pending" },
      { name: "bob", age: 25, status: "enrolled" },
      { name: "ann", age: 28, status: "enrolled" }
   ]
)

db.userInfo.updateOne(
   { age: { $lt: 18 } },
   { $set: { status: "reject" } }
)

db.userInfo.updateMany(
   { age: { $lt: 18 } },
   { $set: { status: "reject" } }
)

db.userInfo.replaceOne(
   { name: "sue" },
   { name: "amy", age : 25, score: "enrolled" }
)

13.delete

db.userInfo.deleteOne(
   { status: "reject" }
)

db.userInfo.deleteMany(
   { status: "reject" }
)

db.userInfo.remove(
   { status: "D" }
)