MongoDB 集合的插入、更新、刪除操作
--建立集合
> db.restaurants.insert({})
2016-06-03T16:05:08.428-0700 I COMMAND [conn4] command test.restaurants command: insert { insert: "restaurants", documents: [ { _id: ObjectId('57520d24f435fd6c606d67a0') } ], ordered: true }
ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: { acquireCount: { w: 1, W:
1 } } } protocol:op_command 140ms
WriteResult({ "nInserted" : 1 })
> show collections;
restaurants
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0") }
--查詢集合裡面的文件
> db.restaurants.find()
{ "_id" : ObjectId("574466fc4ecd57851a197423"), "address" : { "street" : "2 Avenue", "zipcode" : "10075", "building" : "1480", "coord" : [ -73.9557413, 40.7720266 ] }, "borough" : "Manhattan",
"cuisine" :
"Italian", "grades" : [ { "date" : ISODate("2014-10-01T00:00:00Z"), "grade" : "A", "score" : 11 }, { "date" : ISODate("2014-01-16T00:00:00Z"), "grade" : "B", "score" : 17 } ], "name" : "Vella",
"restaurant_id" : "41704620" }
> db.restaurants.findOne()
{
"_id" : ObjectId("574466fc4ecd57851a197423"),
"address" : {
"street" : "2 Avenue",
"zipcode" : "10075",
"building" : "1480",
"coord" : [
-73.9557413,
40.7720266
]
},
"borough" : "Manhattan",
"cuisine" : "Italian",
"grades" : [
{
"date" : ISODate("2014-10-01T00:00:00Z"),
"grade" : "A",
"score" : 11
},
{
"date" : ISODate("2014-01-16T00:00:00Z"),
"grade" : "B",
"score" : 17
}
],
"name" : "Vella",
"restaurant_id" : "41704620"
}
--刪除集合
> db.restaurants.drop()
2016-06-03T16:02:51.910-0700 I COMMAND [conn4] CMD: drop test.restaurants
2016-06-03T16:02:52.073-0700 I COMMAND [conn4] command test.restaurants command: drop { drop: "restaurants" } keyUpdates:0 writeConflicts:0 numYields:0 reslen:64 locks:{ Global: { acquireCount: {
r: 1, w: 1 } }, Database: { acquireCount: { W: 1 } } } protocol:op_command 152ms
true
> db.restaurants.find()
--插入單條文件
> show collections;
restaurants
> db.restaurants.find()
2016-06-03T08:26:09.624-0700 I COMMAND [conn4] command test.restaurants command: find { find: "restaurants", filter: {} } planSummary: COLLSCAN keysExamined:0 docsExamined:0 cursorExhausted:1
keyUpdates:0 writeConflicts:0 numYields:1 nreturned:0 reslen:107 locks:{ Global: { acquireCount: { r: 4 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 } } }
protocol:op_command 186ms
> db.restaurants.find()
> db.restaurants.insert({"bar" : "baz"})
2016-06-03T08:27:32.007-0700 I COMMAND [conn4] command test.restaurants command: insert { insert: "restaurants", documents: [ { _id: ObjectId('5751a1e3f435fd6c606d679f'), bar: "baz" } ], ordered:
true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 1, w: 1 } }, Database: { acquireCount: { w: 1 } }, Collection: { acquireCount: { w: 1 } }
} protocol:op_command 210ms
WriteResult({ "nInserted" : 1 })
> db.restaurants.find()
{ "_id" : ObjectId("5751a1e3f435fd6c606d679f"), "bar" : "baz" }
--批次插入文件
> db.restaurants.insert([{"_id" : 0}, {"_id" : 1}, {"_id" : 2}])
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 3,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
> db.restaurants.find()
{ "_id" : ObjectId("5751a1e3f435fd6c606d679f"), "bar" : "baz" }
{ "_id" : 0 }
{ "_id" : 1 }
{ "_id" : 2 }
--更新文件
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0") }
> pos=({"phone":18210000000,"Adreess" : "Beijing Haidian Street"})
{ "phone" : 18210000000, "Adreess" : "Beijing Haidian Street" }
> db.restaurants.update({"_id" : ObjectId("57520d24f435fd6c606d67a0")}, pos)
2016-06-03T16:14:38.871-0700 I WRITE [conn4] update test.restaurants query: { _id: ObjectId('57520d24f435fd6c606d67a0') } update: { phone: 18210000000.0, Adreess: "Beijing Haidian Street" }
keysExamined:1 docsExamined:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: {
acquireCount: { w: 2 } } } 142ms
2016-06-03T16:14:38.871-0700 I COMMAND [conn4] command test.$cmd command: update { update: "restaurants", updates: [ { q: { _id: ObjectId('57520d24f435fd6c606d67a0') }, u: { phone: 18210000000.0,
Adreess: "Beijing Haidian Street" }, multi: false, upsert: false } ], ordered: true } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database:
{ acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 2 } } } protocol:op_command 142ms
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0"), "phone" : 18210000000, "Adreess" : "Beijing Haidian Street" }
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 20 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> joe = db.people.findOne({"name" : "joe", "age" : 20});
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 20 }
> joe.age++;
20
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")}, joe)
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
--刪除文件
> db.restaurants.remove({"_id" : 1})
WriteResult({ "nRemoved" : 1 })
--使用修改器
--"$set"用來指定一個欄位的值。如果這個欄位不存在，則建立它。這對更新模式或者增加使用者定義的鍵來說非常方便。
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("57522660f435fd6c606d67a1")},{"$set" : {"favorite book" : "War and Peace"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")},{"$set" : {"favorite book" : "Green Eggs and Ham"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21, "favorite book" : "Green Eggs and Ham" }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("5752268bf435fd6c606d67a3")},{"$set" : {"favorite book" : ["Cat's Cradle", "Foundation Trilogy", "Ender's Game"]}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21, "favorite book" : "Green Eggs and Ham" }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
> db.people.insert({"name" : "Neo", "age" : 35, "personal info" : {"Adrees" : "Beijing", "Phone" : 18500000005}})
WriteResult({ "nInserted" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
{ "_id" : ObjectId("57540a73f435fd6c606d67a8"), "name" : "Neo", "age" : 35, "personal info" : { "Adrees" : "Beijing", "Phone" : 18500000005 } }
> db.people.update({"_id" : ObjectId("57540a73f435fd6c606d67a8")},{"$set" : {"Phone" : 18000000000}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
{ "_id" : ObjectId("57540a73f435fd6c606d67a8"), "name" : "Neo", "age" : 35, "personal info" : { "Adrees" : "Beijing", "Phone" : 18500000005 }, "Phone" : 18000000000 }
--"$unset"完全刪除某個鍵
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")},{"$unset" : {"favorite book" : 1}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
--"$inc"修改器用來增加已有鍵的值，如果該鍵不存在就建立一個，專門用於增加（和減少）數字的。對於更新分析資料、投票或者其他有變化資料的地方，使用這個都會非常方便。
> db.games.insert({"game" : "pinball", "user" : "joe"})
2016-06-11T02:31:48.943-0700 I COMMAND [conn4] command test.games command: insert { insert: "games", documents: [ { _id: ObjectId('575bda83f435fd6c606d67a9'), game: "pinball", user: "joe" } ],
ordered: true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: {
acquireCount: { w: 1, W: 1 } } } protocol:op_command 733ms
WriteResult({ "nInserted" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe"
}
> db.games.update({"game" : "pinball", "user" : "joe"},{"$inc" : {"score" : 50}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe",
"score" : 50
}
> db.games.update({"game" : "pinball", "user" : "joe"},{"$inc" : {"score" : 10000}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe",
"score" : 10050
}
--"$push"會向已有的陣列末尾加入一個元素，要是沒有就建立一個新的陣列。
> db.blog.posts.insert({"title" : "A blog post", "contents" : "personal information"})
WriteResult({ "nInserted" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information"
}
> db.blog.findOne()
null
> db.blog.find()
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information"
}
> db.blog.posts.update({"title" : "A blog post"}, {"$push" : {"comments" : {"name" : "joe", "email" : "joe@example.com", "content" : "nice post."}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information",
"comments" : [
{
"name" : "joe",
"email" : "joe@example.com",
"content" : "nice post."
}
]
}
> db.blog.posts.update({"title" : "A blog post"}, {"$push" : {"comments" : {"name" : "bob", "email" : "bob@example.com", "content" : "good post."}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information",
"comments" : [
{
"name" : "joe",
"email" : "joe@example.com",
"content" : "nice post."
},
{
"name" : "bob",
"email" : "bob@example.com",
"content" : "good post."
}
]
}
--將陣列作為資料集使用
> db.users.insert({"username" : "joe", "emails" : ["jose@example.com", "joe@gmail.com", "joe@yahoo.com"]})
WriteResult({ "nInserted" : 1 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : "jose@gmail.com"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : "joe@gmail.com"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : {"$each" : ["joe@gmail.com" ,"jose@gmail.com"]}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
>
--刪除元素
> db.lists.insert({"todo" : ["dishes" , "laundry", "dry cleaning"]})
2016-06-11T03:26:01.394-0700 I COMMAND [conn4] command test.lists command: insert { insert: "lists", documents: [ { _id: ObjectId('575be738f435fd6c606d67ac'), todo: [ "dishes", "laundry", "dry
cleaning" ] } ], ordered: true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } },
Collection: { acquireCount: { w: 1, W: 1 } } } protocol:op_command 434ms
WriteResult({ "nInserted" : 1 })
> db.lists.findOne()
2016-06-11T03:26:21.355-0700 I COMMAND [conn4] command test.lists command: find { find: "lists", filter: {}, limit: 1.0, singleBatch: true } planSummary: COLLSCAN keysExamined:0 docsExamined:1
cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:0 nreturned:1 reslen:186 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r:
1 } } } protocol:op_command 102ms
{
"_id" : ObjectId("575be738f435fd6c606d67ac"),
"todo" : [
"dishes",
"laundry",
"dry cleaning"
]
}
> db.lists.find()
{ "_id" : ObjectId("575be738f435fd6c606d67ac"), "todo" : [ "dishes", "laundry", "dry cleaning" ] }
> db.lists.update({}, {"$pull" : {"todo" : "laundry"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.lists.findOne()
{
"_id" : ObjectId("575be738f435fd6c606d67ac"),
"todo" : [
"dishes",
"dry cleaning"
]
}
> db.restaurants.insert({})
2016-06-03T16:05:08.428-0700 I COMMAND [conn4] command test.restaurants command: insert { insert: "restaurants", documents: [ { _id: ObjectId('57520d24f435fd6c606d67a0') } ], ordered: true }
ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: { acquireCount: { w: 1, W:
1 } } } protocol:op_command 140ms
WriteResult({ "nInserted" : 1 })
> show collections;
restaurants
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0") }
--查詢集合裡面的文件
> db.restaurants.find()
{ "_id" : ObjectId("574466fc4ecd57851a197423"), "address" : { "street" : "2 Avenue", "zipcode" : "10075", "building" : "1480", "coord" : [ -73.9557413, 40.7720266 ] }, "borough" : "Manhattan",
"cuisine" :
"Italian", "grades" : [ { "date" : ISODate("2014-10-01T00:00:00Z"), "grade" : "A", "score" : 11 }, { "date" : ISODate("2014-01-16T00:00:00Z"), "grade" : "B", "score" : 17 } ], "name" : "Vella",
"restaurant_id" : "41704620" }
> db.restaurants.findOne()
{
"_id" : ObjectId("574466fc4ecd57851a197423"),
"address" : {
"street" : "2 Avenue",
"zipcode" : "10075",
"building" : "1480",
"coord" : [
-73.9557413,
40.7720266
]
},
"borough" : "Manhattan",
"cuisine" : "Italian",
"grades" : [
{
"date" : ISODate("2014-10-01T00:00:00Z"),
"grade" : "A",
"score" : 11
},
{
"date" : ISODate("2014-01-16T00:00:00Z"),
"grade" : "B",
"score" : 17
}
],
"name" : "Vella",
"restaurant_id" : "41704620"
}
--刪除集合
> db.restaurants.drop()
2016-06-03T16:02:51.910-0700 I COMMAND [conn4] CMD: drop test.restaurants
2016-06-03T16:02:52.073-0700 I COMMAND [conn4] command test.restaurants command: drop { drop: "restaurants" } keyUpdates:0 writeConflicts:0 numYields:0 reslen:64 locks:{ Global: { acquireCount: {
r: 1, w: 1 } }, Database: { acquireCount: { W: 1 } } } protocol:op_command 152ms
true
> db.restaurants.find()
--插入單條文件
> show collections;
restaurants
> db.restaurants.find()
2016-06-03T08:26:09.624-0700 I COMMAND [conn4] command test.restaurants command: find { find: "restaurants", filter: {} } planSummary: COLLSCAN keysExamined:0 docsExamined:0 cursorExhausted:1
keyUpdates:0 writeConflicts:0 numYields:1 nreturned:0 reslen:107 locks:{ Global: { acquireCount: { r: 4 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 } } }
protocol:op_command 186ms
> db.restaurants.find()
> db.restaurants.insert({"bar" : "baz"})
2016-06-03T08:27:32.007-0700 I COMMAND [conn4] command test.restaurants command: insert { insert: "restaurants", documents: [ { _id: ObjectId('5751a1e3f435fd6c606d679f'), bar: "baz" } ], ordered:
true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 1, w: 1 } }, Database: { acquireCount: { w: 1 } }, Collection: { acquireCount: { w: 1 } }
} protocol:op_command 210ms
WriteResult({ "nInserted" : 1 })
> db.restaurants.find()
{ "_id" : ObjectId("5751a1e3f435fd6c606d679f"), "bar" : "baz" }
--批次插入文件
> db.restaurants.insert([{"_id" : 0}, {"_id" : 1}, {"_id" : 2}])
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 3,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
> db.restaurants.find()
{ "_id" : ObjectId("5751a1e3f435fd6c606d679f"), "bar" : "baz" }
{ "_id" : 0 }
{ "_id" : 1 }
{ "_id" : 2 }
--更新文件
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0") }
> pos=({"phone":18210000000,"Adreess" : "Beijing Haidian Street"})
{ "phone" : 18210000000, "Adreess" : "Beijing Haidian Street" }
> db.restaurants.update({"_id" : ObjectId("57520d24f435fd6c606d67a0")}, pos)
2016-06-03T16:14:38.871-0700 I WRITE [conn4] update test.restaurants query: { _id: ObjectId('57520d24f435fd6c606d67a0') } update: { phone: 18210000000.0, Adreess: "Beijing Haidian Street" }
keysExamined:1 docsExamined:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: {
acquireCount: { w: 2 } } } 142ms
2016-06-03T16:14:38.871-0700 I COMMAND [conn4] command test.$cmd command: update { update: "restaurants", updates: [ { q: { _id: ObjectId('57520d24f435fd6c606d67a0') }, u: { phone: 18210000000.0,
Adreess: "Beijing Haidian Street" }, multi: false, upsert: false } ], ordered: true } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database:
{ acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 2 } } } protocol:op_command 142ms
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.restaurants.find()
{ "_id" : ObjectId("57520d24f435fd6c606d67a0"), "phone" : 18210000000, "Adreess" : "Beijing Haidian Street" }
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 20 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> joe = db.people.findOne({"name" : "joe", "age" : 20});
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 20 }
> joe.age++;
20
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")}, joe)
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
--刪除文件
> db.restaurants.remove({"_id" : 1})
WriteResult({ "nRemoved" : 1 })
--使用修改器
--"$set"用來指定一個欄位的值。如果這個欄位不存在，則建立它。這對更新模式或者增加使用者定義的鍵來說非常方便。
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65 }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("57522660f435fd6c606d67a1")},{"$set" : {"favorite book" : "War and Peace"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")},{"$set" : {"favorite book" : "Green Eggs and Ham"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21, "favorite book" : "Green Eggs and Ham" }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49 }
> db.people.update({"_id" : ObjectId("5752268bf435fd6c606d67a3")},{"$set" : {"favorite book" : ["Cat's Cradle", "Foundation Trilogy", "Ender's Game"]}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21, "favorite book" : "Green Eggs and Ham" }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
> db.people.insert({"name" : "Neo", "age" : 35, "personal info" : {"Adrees" : "Beijing", "Phone" : 18500000005}})
WriteResult({ "nInserted" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
{ "_id" : ObjectId("57540a73f435fd6c606d67a8"), "name" : "Neo", "age" : 35, "personal info" : { "Adrees" : "Beijing", "Phone" : 18500000005 } }
> db.people.update({"_id" : ObjectId("57540a73f435fd6c606d67a8")},{"$set" : {"Phone" : 18000000000}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
{ "_id" : ObjectId("57540a73f435fd6c606d67a8"), "name" : "Neo", "age" : 35, "personal info" : { "Adrees" : "Beijing", "Phone" : 18500000005 }, "Phone" : 18000000000 }
--"$unset"完全刪除某個鍵
> db.people.update({"_id" : ObjectId("57522683f435fd6c606d67a2")},{"$unset" : {"favorite book" : 1}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.people.find()
{ "_id" : ObjectId("57522660f435fd6c606d67a1"), "name" : "joe", "age" : 65, "favorite book" : "War and Peace" }
{ "_id" : ObjectId("57522683f435fd6c606d67a2"), "name" : "joe", "age" : 21 }
{ "_id" : ObjectId("5752268bf435fd6c606d67a3"), "name" : "joe", "age" : 49, "favorite book" : [ "Cat's Cradle", "Foundation Trilogy", "Ender's Game" ] }
--"$inc"修改器用來增加已有鍵的值，如果該鍵不存在就建立一個，專門用於增加（和減少）數字的。對於更新分析資料、投票或者其他有變化資料的地方，使用這個都會非常方便。
> db.games.insert({"game" : "pinball", "user" : "joe"})
2016-06-11T02:31:48.943-0700 I COMMAND [conn4] command test.games command: insert { insert: "games", documents: [ { _id: ObjectId('575bda83f435fd6c606d67a9'), game: "pinball", user: "joe" } ],
ordered: true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: {
acquireCount: { w: 1, W: 1 } } } protocol:op_command 733ms
WriteResult({ "nInserted" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe"
}
> db.games.update({"game" : "pinball", "user" : "joe"},{"$inc" : {"score" : 50}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe",
"score" : 50
}
> db.games.update({"game" : "pinball", "user" : "joe"},{"$inc" : {"score" : 10000}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.games.findOne()
{
"_id" : ObjectId("575bda83f435fd6c606d67a9"),
"game" : "pinball",
"user" : "joe",
"score" : 10050
}
--"$push"會向已有的陣列末尾加入一個元素，要是沒有就建立一個新的陣列。
> db.blog.posts.insert({"title" : "A blog post", "contents" : "personal information"})
WriteResult({ "nInserted" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information"
}
> db.blog.findOne()
null
> db.blog.find()
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information"
}
> db.blog.posts.update({"title" : "A blog post"}, {"$push" : {"comments" : {"name" : "joe", "email" : "joe@example.com", "content" : "nice post."}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information",
"comments" : [
{
"name" : "joe",
"email" : "joe@example.com",
"content" : "nice post."
}
]
}
> db.blog.posts.update({"title" : "A blog post"}, {"$push" : {"comments" : {"name" : "bob", "email" : "bob@example.com", "content" : "good post."}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.blog.posts.findOne()
{
"_id" : ObjectId("575bdd81f435fd6c606d67aa"),
"title" : "A blog post",
"contents" : "personal information",
"comments" : [
{
"name" : "joe",
"email" : "joe@example.com",
"content" : "nice post."
},
{
"name" : "bob",
"email" : "bob@example.com",
"content" : "good post."
}
]
}
--將陣列作為資料集使用
> db.users.insert({"username" : "joe", "emails" : ["jose@example.com", "joe@gmail.com", "joe@yahoo.com"]})
WriteResult({ "nInserted" : 1 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : "jose@gmail.com"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : "joe@gmail.com"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
> db.users.update({"_id" : ObjectId("575bdf87f435fd6c606d67ab")}, {"$addToSet" : {"emails" : {"$each" : ["joe@gmail.com" ,"jose@gmail.com"]}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })
> db.users.find();
{ "_id" : ObjectId("575bdf87f435fd6c606d67ab"), "username" : "joe", "emails" : [ "jose@example.com", "joe@gmail.com", "joe@yahoo.com", "jose@gmail.com" ] }
>
--刪除元素
> db.lists.insert({"todo" : ["dishes" , "laundry", "dry cleaning"]})
2016-06-11T03:26:01.394-0700 I COMMAND [conn4] command test.lists command: insert { insert: "lists", documents: [ { _id: ObjectId('575be738f435fd6c606d67ac'), todo: [ "dishes", "laundry", "dry
cleaning" ] } ], ordered: true } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:25 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } },
Collection: { acquireCount: { w: 1, W: 1 } } } protocol:op_command 434ms
WriteResult({ "nInserted" : 1 })
> db.lists.findOne()
2016-06-11T03:26:21.355-0700 I COMMAND [conn4] command test.lists command: find { find: "lists", filter: {}, limit: 1.0, singleBatch: true } planSummary: COLLSCAN keysExamined:0 docsExamined:1
cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:0 nreturned:1 reslen:186 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r:
1 } } } protocol:op_command 102ms
{
"_id" : ObjectId("575be738f435fd6c606d67ac"),
"todo" : [
"dishes",
"laundry",
"dry cleaning"
]
}
> db.lists.find()
{ "_id" : ObjectId("575be738f435fd6c606d67ac"), "todo" : [ "dishes", "laundry", "dry cleaning" ] }
> db.lists.update({}, {"$pull" : {"todo" : "laundry"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.lists.findOne()
{
"_id" : ObjectId("575be738f435fd6c606d67ac"),
"todo" : [
"dishes",
"dry cleaning"
]
}
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-2121146/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- hibernateHQl批量插入、刪除、更新
- SQL Cookbook—插入、更新與刪除SQL
- GIS資料的查詢，插入，刪除，更新（ArcEngine）
- MongoDB 資料庫建立刪除、表（集合）建立刪除、資料增刪改查MongoDB資料庫
- Unfolder使用教程：如何插入，刪除和更新物件物件
- 【typeorm】typeorm官方文件querybuilder插入更新刪除部分ORMUI
- MSSQL Merge [Into]（一鍵式更新、插入、刪除）SQL
- 使用 MERGE 插入、更新和刪除資料
- 雙向連結串列的操作(插入和刪除)
- .NET 資料庫大資料 方案（插入、更新、刪除、查詢 、插入或更新）資料庫大資料
- MySQL(四) 資料表的插入、更新、刪除資料MySql
- 第15 16課 資料的插入更新和刪除
- 簡單查詢、插入、更新、刪除SQL語句SQL
- MongoDB（7）- 文件插入操作MongoDB
- MongoDB資料庫中更新與刪除資料MongoDB資料庫
- kettle 實時同步資料（插入/更新/刪除資料）
- mysql 資料插入和更新及刪除詳情FSSHMySql
- 單連結串列的插入刪除操作(c++實現)C++
- MongoDB 刪除文件MongoDB
- mysql刪除和更新操作對效能的影響MySql
- windows10更新助手怎麼刪除_windows10更新助手刪除操作方法Windows
- c語言順序棧常規插入刪除操作C語言
- MongoDB更新（update）操作MongoDB
- SQL的資料庫操作：新增、更新、刪除、查詢SQL資料庫
- Java後端--29--Mybatis的更新和刪除操作Java後端MyBatis
- JS模擬陣列操作（新增、刪除、插入、排序、反轉）JS陣列排序
- 2.1趣說什麼是陣列，以及資料的讀取、更新、插入、刪除等操作程式碼（1）陣列
- 2.1趣說什麼是陣列，以及資料的讀取、更新、插入、刪除等操作程式碼（2）陣列
- 怎樣刪除w10更新檔案提示_win10更新檔案提示刪除如何操作Win10
- Oracle 的 merge 更新和插入操作Oracle
- 連結串列基本操作（建立，插入，查詢，刪除）-C語言C語言
- MongoDB之資料刪除MongoDB
- Yii 1.0資料庫操作 查詢、增加、更新、刪除資料庫
- Repeater控制元件實現編輯、更新、刪除操作控制元件
- MongoDB增刪改查操作MongoDB
- 有序列表和集合插入操作的耗時差距
- win10更新失敗記錄怎麼刪除_win10更新失敗記錄刪除操作方法Win10
- mongodb刪除重複資料MongoDB