mongoDB删除某个字段(key)

时间：2018-01-13 19:33:51 阅读：522 评论：0 收藏：0 [点我收藏+]

使用 db.表名.update 配合$unset 使用

例如我们的表noPk 有两个列有字段名是script_type 我们要删除script_type=kshell字段

> db.noPK.find()

{ "_id" : ObjectId("5a50642b908e6b07a84472a2"), "name" : "javascript", "value" : "vue.js" }

{ "_id" : ObjectId("5a50655b908e6b07a84472a3"), "name" : "Xshell", "type" : "script" }

{ "_id" : ObjectId("5a506b40908e6b07a84472a4"), "name" : "Xshell", "type" : "script" }

{ "_id" : ObjectId("5a506b9d908e6b07a84472a5"), "name" : "Xshell", "type" : "script", "script_type" : "bash_shell" }

{ "_id" : ObjectId("5a50703c908e6b07a84472a6"), "name" : "shell", "type" : "script", "script_type" : "kshell" }

>

删除:

> db.noPK.update({"name": "shell"}, {$unset:{"script_type":"kshell"}})

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.noPK.find()

{ "_id" : ObjectId("5a50642b908e6b07a84472a2"), "name" : "javascript", "value" : "vue.js" }

{ "_id" : ObjectId("5a50655b908e6b07a84472a3"), "name" : "Xshell", "type" : "script" }

{ "_id" : ObjectId("5a506b40908e6b07a84472a4"), "name" : "Xshell", "type" : "script" }

{ "_id" : ObjectId("5a506b9d908e6b07a84472a5"), "name" : "Xshell", "type" : "script", "script_type" : "bash_shell" }

{ "_id" : ObjectId("5a50703c908e6b07a84472a6"), "name" : "shell", "type" : "script" }

>

原文：https://www.cnblogs.com/SunshineLittleCat/p/8280096.html

踩

(0)

评论一句话评论（0）

分享档案

更多>