{"id":310,"date":"2012-03-16T20:43:12","date_gmt":"2012-03-16T12:43:12","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=310"},"modified":"2014-01-16T20:54:58","modified_gmt":"2014-01-16T12:54:58","slug":"mongodb%e5%ad%a6%e4%b9%a002-%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=310","title":{"rendered":"MongoDB\u5b66\u4e6002–\u589e\u5220\u6539\u67e5\u64cd\u4f5c"},"content":{"rendered":"
MongoDB\u7684\u589e\u5220\u6539\u67e5\u64cd\u4f5c<\/p>\n
\n
    \n
  1. INSERT\u64cd\u4f5c:\n
      \n
    1. \u5355\u6761\u63d2\u5165(\u53ef\u4ee5\u4f7f\u7528js\u7684\u8bed\u6cd5); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
    2. \u6279\u91cf\u63d2\u5165:mongodb\u4e2d\u5e76\u6ca1\u6709\u63d0\u4f9b\u6279\u91cf\u63d2\u5165\u7684\u8bed\u6cd5,\u4f46\u662f\u9ad8\u7ea7\u8bed\u8a00\u4e2d\u63d0\u4f9b\u4e86\u4e0emongodb\u6279\u91cf\u63d2\u5165\u7684\u63a5\u53e3,\u4e5f\u53ef\u4ee5\u901a\u8fc7for\u5faa\u73af\u6765\u6a21\u62df;<\/li>\n
    3. insert\u548csave\u7684\u533a\u522b:\n
        \n
      1. \u5982\u679c\u4e0d\u4f7f\u7528_id\u5217,\u4e24\u4e2a\u51fd\u6570\u6ca1\u6709\u533a\u522b\u90fd\u662f\u63d2\u5165\u6570\u636e;<\/li>\n
      2. \u5982\u679c\u4f7f\u7528\u4e86_id\u5217,insert\u63d2\u5165_id\u91cd\u590d\u7684\u8bdd\u4f1a\u62a5\u9519;save\u63d2\u5165_id\u91cd\u590d\u7684\u8bdd\u4f1a\u8c03\u7528upsert,\u5373\u5b58\u5728\u5c31\u66f4\u65b0,\u4e0d\u5b58\u5728\u5c31\u63d2\u5165;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
      3. FIND\u64cd\u4f5c:\n
          \n
        1. \u6839\u636e\u6761\u4ef6\u67e5\u8be2:[>, >=, <, <=, !=, =]\u5206\u522b\u5bf9\u5e94[$gt, $gte, $lt, $lte, $ne, \u65e0]\u5173\u952e\u5b57; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
        2. \u591a\u6761\u4ef6\u67e5\u8be2:[and, or, in, notin]\u5206\u522b\u5bf9\u5e94[\u65e0, $or, $in, $nin]\u5173\u952e\u5b57; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
        3. \u6b63\u5219\u8868\u8fbe\u5f0f\u67e5\u8be2; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
        4. \u4f7f\u7528$where\u5b50\u53e5\u67e5\u8be2; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
        5. findOne()\u51fd\u6570\u8fd4\u56de\u6ee1\u8db3\u6761\u4ef6\u7684\u7b2c\u4e00\u6761\u8bb0\u5f55\u6216\u8005\u662fnull:printjson(db.user.findOne({name:”joe”})); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
        6. UPDATE\u64cd\u4f5c:\n
            \n
          1. \u6574\u4f53\u66f4\u65b0; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
          2. \u5c40\u90e8\u66f4\u65b0,\u4f7f\u7528\u4fee\u6539\u5668$inc\u548c$set\u6765\u66f4\u65b0\u67d0\u4e00\u4e2a\u5b57\u6bb5;\n
              \n
            1. $inc:increase\u7684\u7f29\u5199,\u5373\u5728\u539f\u6765\u503c\u7684\u57fa\u7840\u4e0a\u589e\u52a0$inc\u6307\u5b9a\u7684\u503c,\u53ef\u4ee5\u7528\u4e8e\u81ea\u589e\u7684\u4e3b\u952e; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
            2. $set:\u5373\u8bbe\u7f6e\u67d0\u4e2a\u5217\u7684\u503c\u4e3a$set\u6307\u5b9a\u7684\u503c; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
            3. upsert\u64cd\u4f5c:update\u64cd\u4f5c\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u67e5\u8be2\u6761\u4ef6,\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u8981\u66f4\u65b0\u7684\u503c,\u5982\u679c\u8bbe\u7f6e\u7b2c\u4e09\u4e2a\u53c2\u6570\u4e3atrue\u7684\u8bdd,\u5c31\u8868\u793a\u5982\u679c\u5b58\u5728\u8bb0\u5f55\u5c31\u66f4\u65b0,\u5982\u679c\u4e0d\u5b58\u5728\u5c31\u63d2\u5165; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
            4. multi\u64cd\u4f5c:\u6279\u91cf\u66f4\u65b0,\u5982\u679cupdate\u64cd\u4f5c\u5339\u914d\u5230\u4e86\u591a\u6761\u8bb0\u5f55,\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u53ea\u66f4\u65b0\u7b2c\u4e00\u6761,\u5982\u679c\u9700\u8981\u5168\u90e8\u66f4\u65b0\u7684\u8bdd,\u9700\u8981\u628aupdate\u64cd\u4f5c\u4e2d\u7b2c\u56db\u4e2a\u53c2\u6570\u8bbe\u7f6e\u4e3atrue; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
            5. REMOVE\u64cd\u4f5c:\n
                \n
              1. \u6839\u636e\u6761\u4ef6\u5220\u9664:db.mycoll.remove(query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
              2. \u5168\u90e8\u5220\u9664:db.mycoll.remove(); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                <\/div>\n<\/div>\n
                <\/div>\n
                — insert\u64cd\u4f5c;<\/div>\n
                var user={“name”:”jack”, “password”:”12345″, “age”:20, “address”:{“province”:”shanghai”, “city”:”shanghai”}, “favourite”:[“apple”, “banana”]}<\/div>\n
                db.user.insert(user);<\/div>\n
                <\/div>\n
                user.name=”joe”<\/div>\n
                user.age=21<\/div>\n
                user.address={“province”:”beijing”, “city”:”beijing”}<\/div>\n
                user.favourite=[“sanguosha”, “dota”]<\/div>\n
                db.user.insert(user)<\/div>\n
                <\/div>\n
                db.user.find()<\/div>\n
                <\/div>\n
                — find\u64cd\u4f5c;<\/div>\n
                1.\u67e5\u627e\u5e74\u9f84\u5927\u4e8e\u7b49\u4e8e21\u5c81\u7684\u96c6\u5408;<\/div>\n
                db.user.find({“age”:{$gte:21}})<\/div>\n
                2.\u67e5\u627e\u5e74\u9f84\u7b49\u4e8e20\u5c81\u7684\u96c6\u5408;<\/div>\n
                db.user.find({“age”:20})<\/div>\n
                <\/div>\n
                3.\u67e5\u627e\u540d\u79f0\u4e3ajack\u800c\u4e14\u7701\u4efd\u4e3ashanghai\u7684\u96c6\u5408:name=’jack’ and province=’shanghai’;<\/div>\n
                db.user.find({“name”:”jack”, “address.province”:”shanghai”})<\/div>\n
                4.\u67e5\u627e\u7701\u4efd\u4e3a\u4e0a\u6d77\u6216\u8005\u5317\u4eac\u7684\u96c6\u5408:province=’shanghai’ or province=’beijing’;<\/div>\n
                db.user.find({$or:[{“address.province”:”shanghai”}, {“address.province”: “beijing”}]})<\/div>\n
                5.\u67e5\u627e\u7701\u4efd\u5728\u4e0a\u6d77\u6216\u8005\u5317\u4eac\u7684\u96c6\u5408:province in (‘shanghai’, ‘beijing’);<\/div>\n
                db.user.find({“address.province”:{$in:[“shanghai”, “beijing”]}})<\/div>\n
                6.\u67e5\u627e\u7701\u4efd\u4e0d\u5728\u4e0a\u6d77\u7684\u96c6\u5408:province not in (‘shanghai’);<\/div>\n
                db.user.find({“address.province”:{$nin:[“shanghai”]}})<\/div>\n
                <\/div>\n
                7.\u67e5\u627e\u59d3\u540d\u4ee5’j’\u5f00\u5934\u5e76\u4e14\u4ee5’e’\u7ed3\u5c3e\u7684\u96c6\u5408:name like ‘j%e’;<\/div>\n
                db.user.find({“name”:\/^j\/, “name”:\/e$\/})<\/div>\n
                <\/div>\n
                8.\u6761\u4ef6\u590d\u6742\u7684\u65f6\u5019,\u53ef\u4ee5\u4f7f\u7528$where\u5b50\u53e5,\u5176\u5b9e\u5c31\u662fjs\u7684\u51fd\u6570,\u67e5\u627e\u540d\u79f0\u4e3a’jack’\u7684\u96c6\u5408:name=’jack’;<\/div>\n
                db.user.find({$where:function(){return this.name == ‘jack’}})<\/div>\n
                <\/div>\n
                — update\u64cd\u4f5c;<\/div>\n
                1.\u6574\u4f53\u66f4\u65b0\u4e00\u6761\u8bb0\u5f55;<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                var model=db.user.findOne({“name”:”jack”})<\/div>\n
                model.age=30<\/div>\n
                db.user.update({“name”:”jack”}, model)<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                <\/div>\n
                2.\u4f7f\u7528$inc\u4fee\u6539\u5668\u66f4\u65b0\u4e00\u4e2a\u5b57\u6bb5;<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                db.user.update({“name”:”jack”}, {$inc:{“age”:-5}})<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                <\/div>\n
                3.\u4f7f\u7528$set\u4fee\u6539\u5668\u66f4\u65b0\u4e00\u4e2a\u5b57\u6bb5;<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                db.user.update({“name”:”jack”}, {$set:{“age”:20}})<\/div>\n
                db.user.find({“name”:”jack”})<\/div>\n
                <\/div>\n
                4.upsert\u64cd\u4f5c:\u67e5\u627e\u5230\u5c31\u66f4\u65b0,\u6ca1\u6709\u5c31\u63d2\u5165;<\/div>\n
                db.user.find({“name”:”kobe”})<\/div>\n
                db.user.update({“name”:”kobe”}, {$set:{“age”:20}}, true)<\/div>\n
                db.user.find({“name”:”kobe”})<\/div>\n
                <\/div>\n
                5.multi\u64cd\u4f5c:\u6279\u91cf\u66f4\u65b0\u8bb0\u5f55;<\/div>\n
                db.user.find()<\/div>\n
                db.user.update({“age”:{$gte:20}}, {$inc:{“age”:5}}, false, true)<\/div>\n
                db.user.find()<\/div>\n
                <\/div>\n
                — remove\u64cd\u4f5c;<\/div>\n
                1.\u6839\u636e\u6761\u4ef6\u5220\u9664;<\/div>\n
                db.user.find()<\/div>\n
                db.user.remove({“name”:”kobe”})
                \ndb.user.find()<\/div>\n
                <\/div>\n
                2.\u5168\u90e8\u5220\u9664;<\/div>\n
                db.user.remove()<\/div>\n
                db.user.find()
                \ndb.user.count()<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                MongoDB\u7684\u589e\u5220\u6539\u67e5\u64cd\u4f5c INSERT\u64cd\u4f5c: \u5355\u6761\u63d2\u5165(\u53ef\u4ee5\u4f7f\u7528js\u7684\u8bed\u6cd5); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[24,25],"class_list":["post-310","post","type-post","status-publish","format-standard","hentry","category-nosql","tag-mongodb","tag-nosql"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=310"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=310"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}