mongo shell的使用 (3)--显示创建集合与循环插入文档

最新推荐文章于 2023-02-05 00:12:34 发布

奇斯

最新推荐文章于 2023-02-05 00:12:34 发布

阅读量1.3k

点赞数 2

分类专栏： MongoDB 文章标签： mongodb nosql java 数据库

本文链接：https://blog.csdn.net/chechengtao/article/details/117033600

版权

MongoDB 专栏收录该内容

49 篇文章 5 订阅

订阅专栏

1.在执行插入文档之前，可以显示创建集合。

db.createCollection("xxx")。

MongoDB Enterprise > db.createCollection("user1")
{ "ok" : 1 }

MongoDB Enterprise > use mydb
switched to db mydb

MongoDB Enterprise > db
mydb

MongoDB Enterprise > show collections
users

MongoDB Enterprise > db.createCollection("user1")
{ "ok" : 1 }

MongoDB Enterprise > show collections
user1
users
MongoDB Enterprise >

2.使用for循环，插入文档到集合中。

MongoDB Enterprise > for(var i=1;i<20;i++)db.users1.insert({"name":"user"+i,"age":10+i,"gender":"female"})
WriteResult({ "nInserted" : 1 })

MongoDB Enterprise > for(var i=1;i<20;i++)db.users1.insert({"name":"user"+i,"age
":10+i,"gender":"female"})
WriteResult({ "nInserted" : 1 })
MongoDB Enterprise > db.users1.find()
MongoDB Enterprise > db.users1.find()
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9e9"), "name" : "user1", "age" : 11, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9ea"), "name" : "user2", "age" : 12, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9eb"), "name" : "user3", "age" : 13, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9ec"), "name" : "user4", "age" : 14, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9ed"), "name" : "user5", "age" : 15, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9ee"), "name" : "user6", "age" : 16, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9ef"), "name" : "user7", "age" : 17, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f0"), "name" : "user8", "age" : 18, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f1"), "name" : "user9", "age" : 19, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f2"), "name" : "user10", "age" : 20, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f3"), "name" : "user11", "age" : 21, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f4"), "name" : "user12", "age" : 22, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f5"), "name" : "user13", "age" : 23, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f6"), "name" : "user14", "age" : 24, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f7"), "name" : "user15", "age" : 25, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f8"), "name" : "user16", "age" : 26, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9f9"), "name" : "user17", "age" : 27, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9fa"), "name" : "user18", "age" : 28, "gender" : "female" }
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9fb"), "name" : "user19", "age" : 29, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0f9fc"), "name" : "user20", "age" : 30, "gender" : "female" }
Type "it" for more
MongoDB Enterprise >

find命令返回指向结果集的一个游标。游标会显示前20个文档，同时等待寻求遍历（it）显示后20个文档。Type "it" for more语句就是提示用户输入it展示更多的数据记录。

MongoDB Enterprise > it
{ "_id" : ObjectId("60a4ca0e2cd1040071e0f9fd"), "name" : "user21", "age" : 31, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0f9fe"), "name" : "user22", "age" : 32, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0f9ff"), "name" : "user23", "age" : 33, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa00"), "name" : "user24", "age" : 34, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa01"), "name" : "user25", "age" : 35, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa02"), "name" : "user26", "age" : 36, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa03"), "name" : "user27", "age" : 37, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa04"), "name" : "user28", "age" : 38, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa05"), "name" : "user29", "age" : 39, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa06"), "name" : "user30", "age" : 40, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa07"), "name" : "user31", "age" : 41, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa08"), "name" : "user32", "age" : 42, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa09"), "name" : "user33", "age" : 43, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0a"), "name" : "user34", "age" : 44, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0b"), "name" : "user35", "age" : 45, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0c"), "name" : "user36", "age" : 46, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0d"), "name" : "user37", "age" : 47, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0e"), "name" : "user38", "age" : 48, "gender" : "female" }
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0f"), "name" : "user39", "age" : 49, "gender" : "female" }
MongoDB Enterprise >

3.显示指定_id字段。

前面的插入文档示例中，并没有指定_id字段，是被隐式添加的。

如果显示添加_id字段，必须确保该字段的唯一性。

db.users1.insert({"_id":"1001","name":"user1001"})

MongoDB Enterprise > db.users1.insert({"_id":"1001","name":"user1001"})
WriteResult({ "nInserted" : 1 })

使用db.users1.find()查询即可：

MongoDB Enterprise > db.users1.find()
{ "_id" : ObjectId("60a4c91c2cd1040071e0f9e9"), "name" : "user1", "age" : 11, "gender" : "female" }

......
{ "_id" : ObjectId("60a4ca0e2cd1040071e0fa0fgender" : "female" }
{ "_id" : "1001", "name" : "user1001" }