mongoDB删除某个字段(key)
使用 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" }
>