MongoDB 指令碼執行 增、刪、改、查

標籤：exist   foreach   code   each   font   multi   find   god   cti   

集合查詢 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 })

 

MongoDB 指令碼執行 增、刪、改、查