{"id":5397,"date":"2016-10-02T00:50:53","date_gmt":"2016-10-01T16:50:53","guid":{"rendered":"https:\/\/sdeno.com\/?p=5397"},"modified":"2024-05-10T11:09:42","modified_gmt":"2024-05-10T03:09:42","slug":"mongodb%e7%ac%94%e8%ae%b0","status":"publish","type":"post","link":"https:\/\/sdeno.com\/?p=5397","title":{"rendered":"mongodb\u7b14\u8bb0"},"content":{"rendered":"

\u300a\u5728windows\u4e0bmongoDB\u5b89\u88c5\u548c\u914d\u7f6e<\/a>\u300b<\/p>\n

 <\/p>\n

<\/div>
<\/div><\/div><\/div>\"https:\/\/sdeno.com\/wp-content\/uploads\/2016\/10\/mongodb123.png\"<\/figure>\n

 <\/p>\n

\u8fde\u63a5<\/span><\/p>\n

mongo \/\/\u5982\u679c\u7aef\u53e3ip\u4ec0\u4e48\u90fd\u6ca1\u6539\uff0c\u76f4\u63a5\u5728dos\u8f93\u5165mongo\u56de\u8f66\u5c31\u53ef\u4ee5\u81ea\u52a8\u8fde\u63a5shell\r\nmongo --host 127.0.0.1 --port 27017 -u \"root\" -p \"\u5bc6\u7801\" --authenticationDatabase \"admin\" \/\/\u5982\u679cmongo\u5f00\u542f\u7528\u6237\u8ba4\u8bc1\u5c31\u8981\u8f93\u5165\u8d26\u53f7\u5bc6\u7801<\/pre>\n
 <\/p>\n
\u589e\uff1a<\/span>
\n\u521b\u5efa\u6570\u636e\u5e93(\u6ca1\u5c31\u81ea\u52a8\u521b\u5efa\uff0c\u6709\u5c31\u9009\u62e9\u6570\u636e\u5e93)
\nuse xgllseo<\/p>\n
\u521b\u5efa\u5b8c\u6570\u636e\u5e93\u540e\u9700\u8981\u63d2\u5165\u4e00\u6761\u6570\u636e\u624d\u80fd\u663e\u793a\u6570\u8be5\u6570\u636e\u5e93<\/p>\n
db.xgllseo.insert({“name”:”\u5185\u5bb9”})<\/p>\n
 <\/p>\n
\u521b\u5efa\u96c6\u5408
\ndb.createCollection(“\u96c6\u5408\u540d”)
\n\u6dfb\u52a0\u96c6\u5408(\u53ef\u4ee5\u7406\u89e3\u4e3a\u8868)\u3001\u6dfb\u52a0\u5b57\u6bb5\u3001\u63d2\u5165\u5185\u5bb9
\ndb.\u96c6\u5408\u540d.insert({\u5b57\u6bb5\u540d:\u5185\u5bb9})<\/p>\n
\u5faa\u73af\u63d2\u5165\u6570\u636e
\nfor(i=3;i<100;i++)db.\u96c6\u5408\u540d.insert({\u5b57\u6bb5:i})<\/p>\n
\u5220\uff1a<\/span>
\n\u5220\u9664\u6570\u636e\u5e93(\u9009\u4e2d\u6570\u636e\u5e93\u540e\u624d\u64cd\u4f5c)
\ndb.dropDatabase();<\/p>\n
\u5220\u9664\u96c6\u5408(\u5e93)
\ndb.\u96c6\u5408.drop()<\/p>\n
\u5220\u9664\u6240\u6709\u952e\u503c\u5bf9\u76f8\u540c\u7684\u6570\u636e
\ndb.\u96c6\u5408.remove({‘title’:’\u6559\u7a0b’}) \/\/\u5220\u9664\u96c6\u5408\u91cc\u9762\u6761\u4ef6\u662f{‘title’:’\u6559\u7a0b’}\u7684\u6240\u6709\u6587\u6863
\ndb.\u96c6\u5408.remove(); \/\/\u5220\u9664\u6b64\u96c6\u5408\u4e2d\u7684\u6240\u6709\u6587\u6863<\/p>\n
\u5220\u9664\u5b57\u6bb5
\ndb.\u96c6\u5408.update({‘name’:’chenchen’},{$unset:{city:’x’}}) \u00a0\/\/\u5220\u9664city\u5b57\u6bb5<\/p>\n
\u6539\uff1a<\/span>
\n\u4fee\u6539\u6307\u5b9a\u5b57\u6bb5\u5185\u5bb9\uff0c\u53ea\u6539\u7b2c\u4e00\u6761\u51fa\u73b0\u7684\u6570\u636e
\ndb.\u96c6\u5408.update({\u5b57\u6bb5:\u65e7\u503c},{\u5b57\u6bb5:\u65b0\u503c})
\n\u6216\u8005
\ndb.\u96c6\u5408.update({\u5b57\u6bb5:\u65e7\u503c},{$set:{\u5b57\u6bb5:\u65b0\u503c}})<\/p>\n
\u7edf\u4e00\u4fee\u6539\u76f8\u540c\u5b57\u6bb5\u548c\u76f8\u540c\u5185\u5bb9\u7684\u6570\u636e
\ndb.\u96c6\u5408.update({name:”\u54c8\u55bd123″},{$set:{name:”\u54c8\u55bd1234″}},{multi:true})
\n\u6216\u8005
\ndb.\u96c6\u5408.update({name:”\u54c8\u55bd123″},{$set:{name:”\u54c8\u55bd1234″}},false,true)
\n\/\/\u5c06\u591a\u4e2aname:”\u54c8\u55bd123″\u7edf\u4e00\u4fee\u6539\u4e3aname:”\u54c8\u55bd1234″<\/p>\n
\u66f4\u65b0\u7684\u6570\u636e\u5982\u679c\u4e0d\u5b58\u5728\u5219\u81ea\u52a8\u6dfb\u52a0\uff0c\u5982\u679c\u5df2\u7ecf\u5b58\u5728\u5219\u66f4\u65b0\u3002
\ndb.\u96c6\u5408.update({\u5b57\u6bb5:\u65e7\u503c},{\u5b57\u6bb5:\u65b0\u503c},true)<\/p>\n
\u67e5\uff1a<\/span>
\n\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u7248\u672c
\ndb.version()<\/p>\n
\u67e5\u770b\u5f53\u524d\u7cfb\u7edf\u6240\u6709\u6570\u636e\u5e93
\nshow dbs<\/p>\n
\u67e5\u770b\u5f53\u524d\u5207\u6362\u54ea\u4e2a\u6570\u636e\u5e93
\ndb \u6216\u8005 db.getName()<\/p>\n
\u67e5\u770b\u8868(\u8981\u9009\u4e2d\u5e93\u540e\u624d\u80fd\u67e5\u770b\u8868)
\nshow collections \u6216\u8005 show tables \/\/\u4ee5\u5217\u8868\u65b9\u5f0f\u663e\u793a
\ndb.getCollectionNames() \/\/\u4ee5\u6570\u7ec4\u65b9\u5f0f\u663e\u793a<\/p>\n
\u67e5\u770b\u5b57\u6bb5\u5185\u5bb9\u3001\u67e5\u770b\u8868\u91cc\u9762\u6240\u6709\u7ed3\u6784
\ndb.\u96c6\u5408.find({},{}) \u00a0\/\/\u7b2c\u4e00\u53c2\u6570\u67e5\u627e\u6761\u4ef6\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u5426\u663e\u793a\u6307\u5b9a\u5b57\u6bb51\u663e\u793a0\u4e0d\u663e\u793a<\/p>\n
\u67e5\u770b\u4e00\u5171\u51e0\u6761\u6570\u636e
\ndb.\u96c6\u5408.find().count()<\/p>\n
\u4ec5\u4ec5\u67e5\u770b\u4e00\u6761\u6570\u636e
\ndb.\u96c6\u5408.findOne()<\/p>\n
\u6761\u4ef6\u641c\u7d22
\ndb.xgllseo.find().skip(3).limit(2).sort({x:1})
\n\/\/\u5148\u67e5\u627exgllseo\u96c6\u5408\u7684\u6240\u6709\u6570\u636e\uff0c\u5ffd\u7565\u524d3\u6761(\u4ece\u7b2c4\u6761\u5f00\u59cb\u67e5\u627e)\uff0c\u9650\u5236\u53ea\u8fd4\u56de2\u6761\uff0c\u6309\u5b57\u6bb5\u540dx\u7684\u503c\u6392\u5217(1\u662f\u6b63\u5e8f\uff0c-1\u662f\u5012\u5e8f)<\/p>\n
\u6a21\u7cca\u67e5\u8be2\uff0c\u914d\u5408\u6b63\u5219\u4f7f\u7528\uff08\u6b63\u5219\u7528\u597d\u529f\u80fd\u5f88\u5f3a\u5927\uff09
\ndb.\u96c6\u5408.find({name:\/^De\/}); \/\/\u641c\u7d22\u5b57\u6bb5name\u7684\u503c\uff0c\u4e14\u5f00\u5934\u662fDe\u7684\u5173\u952e\u8bcd\u7684\u6240\u6709\u6570\u636e
\n(>) \u5927\u4e8e – $gt
\n(<) \u5c0f\u4e8e – $lt
\n(>=) \u5927\u4e8e\u7b49\u4e8e – $gte
\n(<= ) \u5c0f\u4e8e\u7b49\u4e8e – $lte
\n\uff08!= \uff09\u4e0d\u7b49\u4e8e$ne
\n\u67e5\u627e\u67d0\u5b57\u6bb5\u5927\u4e8e100\u7684\u6240\u6709\u6570\u636e
\ndb.\u96c6\u5408.find({link : {$gte : 100}})<\/p>\n
db.\u96c6\u5408.find({link : {$lt :200, $gt : 100}}) \/\/\u4e14<\/span>\uff0c\u5927\u4e8e100\u4e14\u5c0f\u4e8e200
\ndb.\u96c6\u5408.find({$or:[{“haha”:123},{“name”: “\u6211\u6211”}]}) \/\/\u6216(\u591a\u5b57\u6bb5\uff0c\u5355\u4e00\u503c)<\/span>\uff0c\u53ea\u8981\u542b\u6709”haha”:123\u3001”name”: “\u6211\u6211”\u7684\u6570\u636e
\ndb.\u96c6\u5408.find({“age”:{“$in”:[20, 22, 25]}}) \u00a0\/\/\u6216(\u5355\u4e00\u5b57\u6bb5\uff0c\u591a\u503c)<\/span>\uff0c\u67e5\u627e\u5b57\u6bb5\u662fage\u7684\u503c\u662f20\u6216\u800522\u6216\u800525\u7684\u6570\u636e
\ndb.\u96c6\u5408.find({“age”:{“$nin”:[20, 22, 25]}}) \u00a0\/\/\u6216\u975e<\/span>\uff0c\u67e5\u627e\u9664\u4e86\u5b57\u6bb5\u662fage\u7684\u503c\u662f20\u6216\u800522\u6216\u800525\u7684\u6240\u6709\u6570\u636e
\ndb.\u96c6\u5408.find({“likes”: {$gt:50}, $or: [{“by”: “\u83dc\u9e1f\u6559\u7a0b”},{“title”: “MongoDB \u6559\u7a0b”}]}) \/\/\u4e14\u3001\u6216<\/span>\u7ec4\u5408<\/p>\n
\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u6240\u5728\u7684\u670d\u52a1\u5668IP
\ndb.getMongo()<\/p>\n
\u67e5\u770b\u5f53\u524d\u5207\u6362\u6570\u636e\u5e93\u7684\u4fe1\u606f
\ndb.stats()<\/p>\n
\u67e5\u770b\u5f53\u524d\u9009\u4e2d\u54ea\u4e2a\u6570\u636e\u5e93
\ndb<\/p>\n
\u5907\u4efd\u3001\u8fd8\u539f\uff0f\u5bfc\u5165\u3001\u5bfc\u51fa<\/span><\/p>\n
\u5907\u4efd\u6307\u5b9a\u6570\u636e\u5e93\uff1a<\/p>\n
mongodump -h 127.0.0.1:27017 -d xgllseo -o \/Users\/xgllseo\/Desktop\/<\/pre>\n
\u5907\u4efd\u540d\u4e3axgllseo\u7684\u6570\u636e\u5e93\u5e76\u5bfc\u51fa\u5230\u76ee\u5f55\/Users\/xgllseo\/Desktop\/\u4e2d\uff0c\u4e4b\u540e\u4f1a\u5b58\u5728\u4e00\u4e2axgllseo\u7684\u6587\u4ef6\u5939\u3002<\/p>\n
\u8fd8\u539f\u6240\u6709\u6570\u636e\u5e93\uff1a<\/p>\n
mongorestore \/home\/zhangy\/mongodb\/      \/\/\u5c06\u4e4b\u524d\u5907\u4efd\u597d\u7684xgllseo\u76ee\u5f55\u653e\u5165\u5230\/home\/zhangy\/mongodb\/\u76ee\u5f55\u4e2d<\/pre>\n
\u8fd8\u539f\u6307\u5b9a\u6570\u636e\u5e93<\/p>\n
.\/mongorestore -h 127.0.0.1:27017 --db jskoa \/root\/jskoa  \/\/\u8fd8\u539fjskoa\u6570\u636e\u5e93\uff0cjskoa\u76ee\u5f55\u5c31\u662f\u5907\u4efd\u65f6\u751f\u6210\u7684<\/pre>\n
\u4f1a\u5c06\u76ee\u5f55\u00a0\/home\/zhangy\/mongodb\/\u91cc\u9762\u6240\u6709\u7684\u6570\u636e\u5e93\u90fd\u8fd8\u539f<\/p>\n
http:\/\/www.jb51.net\/article\/52498.htm\u00a0<\/a><\/p>\n
\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5<\/span><\/p>\n
\u6b64\u65b9\u6cd5\u662f\u5728ubuntu\u7cfb\u7edf\u4e2d\u4e3a\u51c6\uff0c\u5b89\u88c5\u53c2\u8003\u300aubuntu\u4e0b\u5b89\u88c5mongoDB<\/a>\u300b<\/p>\n
1\u3001\u9996\u5148\u4fee\u6539mongodb\u7684\u914d\u7f6e\u6587\u4ef6 \u8ba9\u5176\u76d1\u542c\u6240\u6709\u5916\u7f51ip\r\n\r\n\u7f16\u8f91\u6587\u4ef6\uff1a\/etc\/mongodb.conf\r\n\r\n\u4fee\u6539\u540e\u7684\u5185\u5bb9\u5982\u4e0b\uff1a\r\n\r\n bind_ip = 0.0.0.0\r\n\r\n port = 27017\r\n\r\n2\u3001\/etc\/init.d\/mongodb restart<\/pre>\n
\u53c2\u8003\uff1ahttp:\/\/www.cnblogs.com\/navy235\/archive\/2012\/05\/03\/2480758.html<\/a><\/p>\n
http:\/\/blog.csdn.net\/drifterj\/article\/details\/7833875<\/a><\/p>\n
http:\/\/blog.csdn.net\/yczz\/article\/details\/5978800<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u300a\u5728windows\u4e0bmongoDB\u5b89\u88c5\u548c\u914d\u7f6e\u300b     \u8fde\u63a5 mongo \/\/\u5982\u679c\u7aef\u53e3ip […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[],"class_list":["post-5397","post","type-post","status-publish","format-standard","hentry","category-mongodb"],"_links":{"self":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/5397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5397"}],"version-history":[{"count":0,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/5397\/revisions"}],"wp:attachment":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}