{"id":3548,"date":"2020-04-20T14:34:43","date_gmt":"2020-04-20T06:34:43","guid":{"rendered":"https:\/\/www.webteach.tw\/?p=3482"},"modified":"2020-04-20T14:34:43","modified_gmt":"2020-04-20T06:34:43","slug":"mongodb-mongodb-command-line-mode-%e7%9a%84%e5%9f%ba%e6%a5%9a%e6%93%8d%e4%bd%9c%e6%8c%87%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/www.webteach.tw\/?p=3548","title":{"rendered":"[ Mongodb ] – Mongodb command line mode \u7684\u57fa\u695a\u64cd\u4f5c\u6307\u4ee4"},"content":{"rendered":"\n

\u9019\u908a\u8a18\u9304\u4e00\u4e0b mongodb command line mode \u7684\u57fa\u695a\u64cd\u4f5c\u6307\u4ee4 \u5f9e\u7121\u5230\u6709\u7684 \u5efa\u7acb collections \u65b0\u589e \u67e5\u8a62 \u66f4\u65b0 \u522a\u9664 \u7b49\u57fa\u672c\u6307\u4ee4\uff0c\u6211\u7684\u74b0\u5883\u662f MongoDB shell version v3.6.3 \u6307\u4ee4\u53ef\u80fd\u6703\u56e0\u4e0d\u540c\u7248\u672c\u6709\u4e9b\u5fae\u7684\u5dee\u7570\u3002<\/p>\n\n\n

mongodb \u7576\u8cc7\u6599\u5eab\u555f\u7528\u9a57\u8b49\u6a21\u5f0f\u5f8c \u6bcf\u500bdb\u90fd\u9700\u8981\u6709\u5c0d\u61c9\u7684 \u5e33\u5bc6\u767b\u5165<\/p>\n\n\n

\u9996\u5148\u767b\u5165\u8d85\u7d1a\u7ba1\u7406\u8005\u5e33\u6236
<\/p>\n\n\n

mongo mongodb:\/\/super:superpwd@172.1.2.3:27017\/admin<\/pre>\n\n\n
\u767b\u5165\u5f8c\u5207\u63db\u5230\u4f60\u8981\u65b0\u589e\u7684db<\/p>\n\n\n
use op_log<\/pre>\n\n\n
\u5207\u63db\u6210\u529f\u6703\u986f\u793a

switched to db op_log<\/p>\n\n\n
\u518d\u4e0b\u65b0\u589e\u4f7f\u7528\u8005<\/strong>\u7684\u6307\u4ee4 <\/p>\n\n\n
db.createUser({user:\"op\",pwd:\"test_pwd\",roles:[{role:\"readWrite\",db:\"op_log\"}]})<\/pre>\n\n\n
\u65b0\u589e\u6210\u529f\u6703\u986f\u793a

<\/p>\n\n\n
Successfully added user: {
     “user” : “op”,
     “roles” : [
         {
             “role” : “readWrite”,
             “db” : “op_log”
         }
     ]
 }<\/p>\n\n\n
\u82e5\u5efa\u932f\u5e33\u865f\u4e5f\u53ef\u4ee5\u4f7f\u7528\u522a\u9664\u4f7f\u7528\u8005<\/strong>\u6307\u4ee4<\/p>\n\n\n
db.runCommand( { dropUser: \"op\" } )<\/pre>\n\n\n
\u518d\u4f86\u5c31\u53ef\u4ee5\u4f7f\u7528\u65b0\u7684\u5e33\u5bc6\u53bb\u767b\u5165\u65b0\u7684db<\/p>\n\n\n
mongo mongodb:\/\/op:test_pwd@172.1.2.3:27017\/op_log<\/pre>\n\n\n
\u767b\u5165\u6210\u529f\u6703\u986f\u793a
 MongoDB shell version v3.6.3
 connecting to: mongodb:\/\/172.31.24.1:27017\/op_log
 MongoDB server version: 3.6.3<\/p>\n\n\n
\u65b0\u589e\u4e00\u7b46\u8cc7\u6599<\/strong> \u6307\u4ee4<\/p>\n\n\n
db.op_log.insert({\"acount\":\"test\"})<\/pre>\n\n\n
\u65b0\u589e\u6210\u529f\u6703\u986f\u793a
 WriteResult({ “nInserted” : 1 })<\/p>\n\n\n
 \u67e5\u8a62<\/strong> \u6307\u4ee4<\/p>\n\n\n
db.op_log.find()<\/pre>\n\n\n
 \u67e5\u8a62\u6210\u529f\u6703\u986f\u793a
 { “_id” : ObjectId(“5e9d2f4eee592e24d2cdc2c7”), “acount” : “test” }<\/p>\n\n\n
\u65b0\u589e\u591a\u7b46\u8cc7\u6599<\/strong> \u6307\u4ee4<\/p>\n\n\n
 db.op_log.insertMany([{\"account\":\"test1\"},{\"account\":\"test2\"}])<\/pre>\n\n\n

 \u65b0\u589e\u6210\u529f\u986f\u793a
 {
     “acknowledged” : true,
     “insertedIds” :          ObjectId(“5e9d38579afa78b4837efc98”),            
                                               ObjectId(“5e9d38579afa78b4837efc99”)     
 }<\/p>\n\n\n
 \u67e5\u8a62 db.op_log.find()
 { “_id” : ObjectId(“5e9d2f4eee592e24d2cdc2c7”), “acount” : “test” }
 { “_id” : ObjectId(“5e9d38579afa78b4837efc98”), “account” : “test1” }
 { “_id” : ObjectId(“5e9d38579afa78b4837efc99”), “account” : “test2” }

 \u9019\u908a\u6703\u767c\u73fe\u767d\u75f4\u7684\u5c0f\u7de8\u6253\u932f\u5b57 account \u6253\u6210 acount, \u9019\u908a\u6211\u5011\u900f\u904e 
save\u6307\u4ee4\u4f86\u4fee\u6539\u6574\u7b46\u8cc7\u6599<\/strong><\/p>\n\n\n
db.op_log.save({\"_id\":ObjectId(\"5e9d2f4eee592e24d2cdc2c7\"),\"account\":\"test\"})<\/pre>\n\n\n

 \u6210\u529f\u6703\u986f\u793a 
 WriteResult({ “nMatched” : 1, “nUpserted” : 0, “nModified” : 1 })<\/p>\n\n\n
\u67e5\u8a62 db.op_log.find()
\n{ “_id” : ObjectId(“5e9d2f4eee592e24d2cdc2c7”), “account” : “test” }
\n{ “_id” : ObjectId(“5e9d38579afa78b4837efc98”), “account” : “test1” }
\n{ “_id” : ObjectId(“5e9d38579afa78b4837efc99”), “account” : “test2” }<\/p>\n\n\n
\u518d\u4f86\u5982\u679c\u53ea\u662f\u60f3\u4fee\u6539\u67d0\u4e00\u500b\u503c<\/strong> \u8209\u4f8b \u6211\u8981\u4fee\u6539\u5c07 account test \u6539\u6210 account test3
 \u4fee\u6539\u6307\u4ee4\u70ba<\/p>\n\n\n
db.op_log.update({\"account\":\"test\"},{$set:{\"account\":\"test3\"}})<\/pre>\n\n\n

    \u8aaa\u660e {“account”:”test”} \u70baquery \u5c31\u985e\u4f3c where \u689d\u4ef6 \uff0c{$set:{“account”:”test3″}} \u8981\u4fee\u6539\u7684\u503c
    \u9019\u908a\u8981\u6ce8\u610f\u9019\u6307\u4ee4\u53ea\u6703\u8b8a\u66f4\u7b2c\u4e00\u7b46\u8cc7\u6599\uff0c\u5982\u679c\u8981\u540c\u6642\u66f4\u65b0\u9762\u540c\u7684\u689d\u4ef6\u8cc7\u6599\u9700\u591a\u52a0 {multi:true} \u6307\u4ee4\u5982\u4e0b<\/p>\n\n\n
db.op_log.update({\"account\":\"test\"},{$set:{\"account\":\"test3\"}},{multi:true})<\/pre>\n\n\n
  \u67e5\u8a62 db.op_log.find()
 { “_id” : ObjectId(“5e9d2f4eee592e24d2cdc2c7”), “account” : “test3” }
 { “_id” : ObjectId(“5e9d38579afa78b4837efc98”), “account” : “test1” }
 { “_id” : ObjectId(“5e9d38579afa78b4837efc99”), “account” : “test2” }<\/p>\n\n\n
\u522a\u9664<\/strong><\/p>\n\n\n
db.op_log.remove({\"_id\":ObjectId(\"5e9d2f4eee592e24d2cdc2c7\")})<\/pre>\n\n\n
\u6210\u529f\u6703\u986f\u793a
 WriteResult({ “nRemoved” : 1 })
 \u67e5\u8a62 db.op_log.find()
 { “_id” : ObjectId(“5e9d38579afa78b4837efc98”), “account” : “test1” }
 { “_id” : ObjectId(“5e9d38579afa78b4837efc99”), “account” : “test2” }<\/p>\n\n\n
\u522a\u9664\u7b26\u5408\u689d\u4ef6\u7684\u591a\u7b46\u8cc7\u6599<\/strong><\/p>\n\n\n
db.op_log.remove({\"account\":\"test4\"})<\/pre>\n\n\n
\u6210\u529f\u6703\u986f\u793a
WriteResult({ “nRemoved” : 2 })<\/p>\n\n\n
\u5b98\u65b9\u5efa\u8b70\u7684\u522a\u9664\u65b9\u5f0f<\/strong><\/p>\n\n\n
\u522a\u9664\u55ae\u7b46\u8cc7\u6599<\/strong><\/p>\n\n\n
db.op_log.deleteOne({\"account\":\"test4\"})
<\/pre>\n\n\n
\u6210\u529f\u6703\u986f\u793a
{ “acknowledged” : true, “deletedCount” : 1 }<\/p>\n\n\n
\u522a\u9664\u591a\u7b46\u8cc7\u6599<\/strong><\/p>\n\n\n
db.op_log.deleteMany({\"account\":\"test4\"})
<\/pre>\n\n\n
\u6210\u529f\u6703\u986f\u793a
{ “acknowledged” : true, “deletedCount” : 3 }<\/p>\n\n\n
\u522a\u9664\u6240\u6709\u8cc7\u6599<\/strong><\/p>\n\n\n
db.op_log.deleteMany({})<\/pre>\n\n\n
\u6210\u529f\u6703\u986f\u793a
{ “acknowledged” : true, “deletedCount” : 6 }<\/p>\n","protected":false},"excerpt":{"rendered":"
\t\t\t\t\u9019\u908a\u8a18\u9304\u4e00\u4e0b mongodb command line mode \u7684\u57fa\u695a\u64cd\u4f5c\u6307\u4ee4 \u5f9e\u7121\u5230\u6709\u7684 \u5efa\u7acb collections \u65b0\u589e \u67e5\u8a62 \u66f4\u65b0 \u522a\u9664 \u7b49\u57fa\u672c\u6307\u4ee4\uff0c\u6211\u7684\u74b0\u5883\u662f MongoDB shell version v3.6.3 \u6307\u4ee4\u53ef\u80fd\u6703\u56e0\u4e0d\u540c\u7248\u672c\u6709\u4e9b\u5fae\u7684\u5dee\u7570\u3002\t\t<\/p>\n","protected":false},"author":1,"featured_media":3825,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[98,186,201,202,203,223,321,322,394,395,588],"class_list":["post-3548","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","tag-add","tag-createuser","tag-delete","tag-deletemany","tag-deleteone","tag-dropuser","tag-insert","tag-insertmany","tag-mongo","tag-mongodb","tag-update","hvn-theme-has-thumbnail"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/3548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3548"}],"version-history":[{"count":0,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/3548\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/media\/3825"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}