MongoDB——增删改查

文档结构：

{

    "_id": ObjectId("5d5e5de597eb2f0b70005d1a"),

    "userId": ,

    "word_records": [

        {

            "word": "helloo",

            "from": "en",

            "to": "hi",

            "update_time": ,

            "create_time":

        },

        {

            "word": "xx",

            "from": "en",

            "to": "hi",

            "update_time": ,

            "create_time":

        }

    ]

}

一个用户想增加一个单词：

db.getCollection("collect_record").update({'userId':1234},{$addToSet:{word_records:{'word':'update2','to':'en','from':'hi'}}})

一个用户想删除一个单词：

db.getCollection("collect_record").update({"userId":123},{"$pull":{"word_records":{"word":"hello"}}})

分页查询某个用户的单词：

db.getCollection("collect_record").findOne({'userId':123},{'word_records':{$slice:[0,2]}})

避免重复插入：

https://blog.csdn.net/wu0che28/article/details/82316933

索引：

db.getCollection("collect_record").createIndex({
userId: NumberInt("1"),
"word_records.from": NumberInt("1"),
"word_records.to": NumberInt("1"),
"word_records.word": NumberInt("1")
}, {
name: "userId_1_word_records.from_1_word_records.to_1_word_records.word_1",
unique: true
});

巴特西

MongoDB——增删改查

最新文章

热门文章