//第一个大{}是条件查询语句，按指定条件增加字段

db.Test.updateMany({'id':2},{$set:{isFree:false, sequence:1}})

// 新增字段

db.assetOrderDetailVO.updateMany({}, { $set: { isZhenxiang: NumberInt(0) } });


//删除字段

db.Test.update({"isFree":{"$exists":true}},{"$unset":{"isFree":null}},{multi:true})



db.userTrade.updateMany({'tradeNo':1007614111171092480}, {$set:{collectState:Number(1)}});



db.userTrade.find({ "tradeNo" :1007614111171092480, "collectState" : 0 })



//更新日期字段-使用id

db.businessTrade.update({'_id':ObjectId("6486b2fd21666a525c024f06")},{$set:{expireTime:ISODate("2025-06-29T23:59:59.000+08:00")}});


db.assetOrderDetailVO.update({'_id':1},{$set:{expireTime:new Date("2021-09-30 23:59:59")}});


//更新日期字段-使用查询条件

db.assetOrderDetailVO.update({orderNo:"JF1613707252344"},{$set:{expireTime:new Date("2025-09-30 23:59:59")}});



db.userTrade.deleteOne({ userId:"7110011003827580" });



//普通单索引

db.userTrade.createIndex({assetNo:-1},{ background: true});


db.userTrade.createIndex({userId:-1},{ background: true})


db.assetOrderDetailVO.createIndex({orderNo:-1},{unique:true,background: true})



//分组统计排序，等同于 select assetNo, count(*) as num_tutorial from mycol group by assetNo order by num_tutorial desc;

db.userTrade.aggregate([{$group : {_id : "$assetNo", num_tutorial : {$sum : 1}}},{

    $sort: { num_tutorial: -1 }

  }])

db.assetOrderDetailVO.aggregate([{$group : {_id : "$orderNo", num_tutorial : {$sum : 1}}},{

    $sort: { num_tutorial: -1 }

  }])

//查询重复

db.getCollection('userTrade').aggregate([

    { $group: { _id : '$assetNo', count: { $sum : 1 } } },

    { $match: { count: { $gt : 1} } }

])



//in 查询条件

db.userTrade.find({"assetNo" : {"$in" : [1, 2, 4]}});



//根据条件批量查询修改

db.userTrade.update({"assetNo" : {"$in" : [1, 2, 4]}},{$set:{expireTime:new Date("2025-09-30 23:59:59")}});




2758,聚优福利全平台通用积分

//修改

db.assetOrderDetailVO.update({'orderNo':'JFSQ870628645654634496'}, {$set:{templateId:Number(11000),templateName:'nihao'}});



// 修改集合属性字段的值

    db.assetOrderDetailVO.update(

  { _id: 1 }, // 查询条件

  { $set: { "companies.$[elem].num": 30 } }, // 更新操作

  { arrayFilters: [{ "elem.grantNo": "S1614064156517" }] } // 数组筛选条件

)


db.assetOrderDetailVO.update(

   {  _id: 1,"companies.grantNo": "S1614064020055"}, //多条件查询

   { "$set": { "companies.$.num" : 110 } }

)


//in 查询条件

db.userTrade.find({

    "assetNo": {

        "$in": [45751422, 45776116, 45776117, 45776124, 45776126, 45776130, 45776135, 45776137,

 45776138, 45776139, 45776151, 45776169, 45776185, 45776204, 45776207, 45776239, 45776262,

 45776264, 45776271, 45776282, 45776309, 45776326, 45776393, 45776404, 45777033, 45777054, 

45777280, 45777293, 45777512, 45777533, 45778932, 45778977, 45778999, 45779023, 45779871,

 45784837, 45785372, 45787060, 45787063, 45793349, 45793364, 45793437, 45794179, 45795365, 

45795584, 45795664, 45797571, 45799676, 45802721, 45802761, 45803253, 45803959, 45815288,

 45816556, 45824688, 45827861, 45833488]

    }

});



//根据条件批量查询修改

db.userTrade.update({

    "assetNo": {

        "$in": [45751422, 45776116, 45776117, 45776124, 45776126, 45776130, 45776135, 45776137, 

45776138, 45776139, 45776151, 45776169, 45776185, 45776204, 45776207, 45776239, 45776262, 

45776264, 45776271, 45776282, 45776309, 45776326, 45776393, 45776404, 45777033, 45777054, 

45777280, 45777293, 45777512, 45777533, 45778932, 45778977, 45778999, 45779023, 45779871, 

45784837, 45785372, 45787060, 45787063, 45793349, 45793364, 45793437, 45794179, 45795365, 

45795584, 45795664, 45797571, 45799676, 45802721, 45802761, 45803253, 45803959, 45815288, 

45816556, 45824688, 45827861, 45833488]

    }

}, {

    $set: {

        expireTime: new Date("2026-06-30 23:59:59")

    }

});