非主键更新
db.getCollection("PAYBILL").find({"CREATE_TIME" : {$gte:"2019-06-02:01:19:39",$lte:"2019-06-04:01:19:39"}}).forEach(function(x){
db.getCollection("PAYBILL").updateMany({SORT_ID:x.SORT_ID},
{$set:{
CREATE_TIME:x.CREATE_TIME.replace(" ",":")
}
})
})
主键更新
db.getCollection("ORDERBILL_SHARD1").find({"TRANTYPE":"313","BUSICODE":"01000016","STATE":"11","ACCOUNTDATE":"20190730","REMARK2"
:{$in:["0000100000"]}}).forEach(function(x){
db.getCollection("ORDERBILL_SHARD1").updateOne({_id:x._id},
{$set:{
SORT_ID:x.REMARK2 + x.ACCOUNTDATE + x.TRADESN
}
})
})
多条数据 update 操作
db.getCollection("hisDetail_newdate").updateMany(
{
"MERC_ID": "826148551378003",
"AC_DT": {
$gte: "20190301"
}
},
{
$set: {
"BNK_TYP": "9001002"
}
}
)