mongdb表里的数据格式如下:
{
"XH" : 1,
"LIB" : [
{
"FLAG" : "AGE",
"DATA" : [
{"NAME":"XIE","VALUE":22},
{"NAME":"XIE","VALUE":25},
{"NAME":"XIE","VALUE":24}
]
}
]
}
要求:把DATA数组内第二个数据的VALUE改为23
语句如下:
db.collection.update({},{$set:{'LIB.$[].DATA.1.VALUE':23}},{multi:true});