MongoDB 脚本执行 增、删、改、查

集合查询 4 db.TableName.find({"listData.listData1.field":2}); 5 非集合查询 6 db.TableName.find({"field":2}); 7 多条件查询 8 db.TableName.find({"field1":1,"field2":"test"}); 9 10 非集合新增11 db.TableName.update({},{$set: {"new_field":1}}, {multi:true}) 12 db.TableName.update({"new_field":{$exists:false}},{$set:{"new_field":NumberInt("0")}},{multi:true})13 14 15 集合新增16 db.Vac_Order.find({}).forEach(function(order){17 order.OrderDetail.forEach(function(detail){18 detail.MappingDetail.forEach(function(mapping){19 if(!mapping.newField){20 mapping.newField=0 //新增字段21  }22  })23  })24 db.Vac_Order.save(order)25 })26 27 非集合删除28 db.TableName.update({}, {$unset: {"new_field":1}},{multi:true}) 29 集合删除30 db.Vac_Order.find({}).forEach(function(order){31 order.OrderDetail.forEach(function(detail){32 detail.MappingDetail.forEach(function(mapping){33 if(mapping.newField){34 delete mapping.newField//删除字段35  }36  })37  })38 db.Vac_Order.save(order)39 })40 41 42 非集合修改43 db.TableName.update({"field":"条件"},{$set:{"field":"新值"}},{multi:true})44 45 集合修改46 db.Vac_Order.find({}).forEach(function(order){47 order.OrderDetail.forEach(function(detail){48 detail.MappingDetail.forEach(function(mapping){49 if(mapping.newField){50 mapping.newField=1//重新赋值51  }52  })53  })54 db.Vac_Order.save(order)55 })

 

相关文章