插入操作(详细)
1.插入一条简单文档
> db.goodstest.insert({name:"《C语言编程》",price:32})
> db.goodstest.insert({_id:21,name:"《java语言编程》",price:33})
> show dbs
admin 0.000GB
goodsdb 0.000GB
local 0.000GB
> use goodsdb
switched to db goodsdb
> db.goodstest.insert({name:"《C语言编程》",price:32})
WriteResult({ "nInserted" : 1 })
> db.goodstest.insert({_id:21,name:"《java语言编程》",price:33})
WriteResult({ "nInserted" : 1 })
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{ "_id" : 21, "name" : "《java语言编程》", "price" : 33 }
2.插入一条复杂文档
> db.goodstest.insert(
... {name:"《C语言》",price:33.2,adddate:"2020-10-1",allow:true,baseinf:{ISBN:1838388,press:"清华大学出版社"},tags:["good","book","it","program"]})
> db.goodstest.insert(
... {name:"《C语言》",price:33.2,adddate:"2020-10-1",allow:true,baseinf:{ISBN:1838388,press:"清华大学出版社"},tags:["good","book","it","program"]})
WriteResult({ "nInserted" : 1 })
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{
"_id" : ObjectId("60744b754a2bf7c4568674b5"),
"name" : "《C语言》",
"price" : 33.2,
"adddate" : "2020-10-1",
"allow" : true,
"baseinf" : {
"ISBN" : 1838388,
"press" : "清华大学出版社"
},
"tags" : [
"good",
"book",
"it",
"program"
]
}
3.插入多条数据
> db.goodstest.insert(
... [
... {item:"小学生教材",name:"《小学一年级语文》",price:12},
... {item:"初中生教材",name:"《初中一年级语文》",price:15},
... ]
//若希望有序输出,则在此位置上补充{ordered:true}
... )
> db.goodstest.insert(
... [
... {item:"小学生教材",name:"《小学一年级语文》",price:12},
... {item:"初中生教材",name:"《初中一年级语文》",price:15},
... ]
//若希望有序输出,则在此位置上补充{ordered:true}
... )
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 2,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{
"_id" : ObjectId("60744b754a2bf7c4568674b5"),
"name" : "《C语言》",
"price" : 33.2,
"adddate" : "2020-10-1",
"allow" : true,
"baseinf" : {
"ISBN" : 1838388,
"press" : "清华大学出版社"
},
"tags" : [
"good",
"book",
"it",
"program"
]
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b6"),
"item" : "小学生教材",
"name" : "《小学一年级语文》",
"price" : 12
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b7"),
"item" : "初中生教材",
"name" : "《初中一年级语文》",
"price" : 15
}
4.用变量方式插入文档
> document=({name:"《c program》",price:45})
> db.goodstest.insert(document)
> document=({name:"《c program》",price:45})
{ "name" : "《c program》", "price" : 45 }
> db.goodstest.insert(document)
WriteResult({ "nInserted" : 1 })
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{
"_id" : ObjectId("60744b754a2bf7c4568674b5"),
"name" : "《C语言》",
"price" : 33.2,
"adddate" : "2020-10-1",
"allow" : true,
"baseinf" : {
"ISBN" : 1838388,
"press" : "清华大学出版社"
},
"tags" : [
"good",
"book",
"it",
"program"
]
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b6"),
"item" : "小学生教材",
"name" : "《小学一年级语文》",
"price" : 12
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b7"),
"item" : "初中生教材",
"name" : "《初中一年级语文》",
"price" : 15
}
{
"_id" : ObjectId("60744d964a2bf7c4568674b8"),
"name" : "《c program》",
"price" : 45
}
5.insertOne()和insertMany()
insertOne() :插入一条文档
> db.goodstest.insertOne({name:"《C语言编程V2》",price:56})
insertMany() :插入多条文档
> db.goodstest.insertMany([
... {name:"pen",price:10},
... {name:"pencil",price:5},
... {name:"cap",price:50}
... ])
> db.goodstest.insertOne({name:"《C语言编程V2》",price:56})
{
"acknowledged" : true,
"insertedId" : ObjectId("607450354a2bf7c4568674bb")
}
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{
"_id" : ObjectId("60744b754a2bf7c4568674b5"),
"name" : "《C语言》",
"price" : 33.2,
"adddate" : "2020-10-1",
"allow" : true,
"baseinf" : {
"ISBN" : 1838388,
"press" : "清华大学出版社"
},
"tags" : [
"good",
"book",
"it",
"program"
]
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b6"),
"item" : "小学生教材",
"name" : "《小学一年级语文》",
"price" : 12
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b7"),
"item" : "初中生教材",
"name" : "《初中一年级语文》",
"price" : 15
}
{
"_id" : ObjectId("60744d964a2bf7c4568674b8"),
"name" : "《c program》",
"price" : 45
}
{
"_id" : ObjectId("607450354a2bf7c4568674bb"),
"name" : "《C语言编程V2》",
"price" : 56
}
> db.goodstest.insertMany([
... {name:"pen",price:10},
... {name:"pencil",price:5},
... {name:"cap",price:50}
... ])
{
"acknowledged" : true,
"insertedIds" : [
ObjectId("607451a64a2bf7c4568674bc"),
ObjectId("607451a64a2bf7c4568674bd"),
ObjectId("607451a64a2bf7c4568674be")
]
}
> db.goodstest.find().pretty()
{
"_id" : ObjectId("60744a0d4a2bf7c4568674b4"),
"name" : "《C语言编程》",
"price" : 32
}
{
"_id" : ObjectId("60744b754a2bf7c4568674b5"),
"name" : "《C语言》",
"price" : 33.2,
"adddate" : "2020-10-1",
"allow" : true,
"baseinf" : {
"ISBN" : 1838388,
"press" : "清华大学出版社"
},
"tags" : [
"good",
"book",
"it",
"program"
]
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b6"),
"item" : "小学生教材",
"name" : "《小学一年级语文》",
"price" : 12
}
{
"_id" : ObjectId("60744c744a2bf7c4568674b7"),
"item" : "初中生教材",
"name" : "《初中一年级语文》",
"price" : 15
}
{
"_id" : ObjectId("60744d964a2bf7c4568674b8"),
"name" : "《c program》",
"price" : 45
}
{
"_id" : ObjectId("607450354a2bf7c4568674bb"),
"name" : "《C语言编程V2》",
"price" : 56
}
{
"_id" : ObjectId("607451a64a2bf7c4568674bc"),
"name" : "pen",
"price" : 10
}
{
"_id" : ObjectId("607451a64a2bf7c4568674bd"),
"name" : "pencil",
"price" : 5
}
{
"_id" : ObjectId("607451a64a2bf7c4568674be"),
"name" : "cap",
"price" : 50
}