如何在mongodb中删除json元素 - how to delete a json element in mogodb?

how to delete a json element in mogodb?

本文关键字：删除 json 元素 mongodb | 更新日期: 2023-09-26

mongodb的内容如下:

{
"_id": 74924,
"bangs": {
    "436": {
        "join_time": 1345624851,
        "status": 1,
        "scores": 0
    },
    "446": {
        "join_time": 1355727257,
        "status": 1,
        "scores": 0
    }
},
"_id": 74926,
"bangs": {
    "436": {
        "join_time": 1345624851,
        "status": 1,
        "scores": 0
    },
    "446": {
        "join_time": 1355727257,
        "status": 1,
        "scores": 0
    }
 }
}

我要删除:

"436": {
        "join_time": 1345624851,
        "status": 1,
        "scores": 0
    },
 where _id=74924

结果将是:

{
"_id": 74924,
"bangs": {
    "446": {
        "join_time": 1355727257,
        "status": 1,
        "scores": 0
    }
},
"_id": 74926,
"bangs": {
    "436": {
        "join_time": 1345624851,
        "status": 1,
        "scores": 0
    },
    "446": {
        "join_time": 1355727257,
        "status": 1,
        "scores": 0
    }
 }
}

我写的代码是这样的:

$mongo->users->users->update(array('_id'=>74924), array('$pull'=>array('bangs'=>436)));

但是记录没有删除

我怎么写代码?
提前感谢!

你可以这样删除它:

db.test.update( { _id:74924 }, { $unset: {"bangs.436":1} } )
// I think this can be written in php like this:
$mongo->users->users->update(array('_id'=>74924), array('$unset'=>array('bangs.436'=>1)));