mb649166f4c151e的博客_mongodb

删除多个文档

db.collection.find().limit(100).forEach(function(doc) { db.collection.remove({_id:doc._id});});

clementine

原创 2023-06-21 00:07:29 112 阅读

复制文档从子文档中提升到文档

"sport": "NFL","team_id": 5,"week_num": 6,"meta": { .... more data ...., "season_year": 2013}变为"sport": "NFL","team_id": 5,"week_num&q

clementine

原创 2023-06-21 00:07:04 79 阅读

预先占位然后删除

预先占位在一个额外的字段，然后取消comments = [ {name : "Name Surname", date : "1970.01.01", text : "this is a placeholder"}, {name : "Name Surname", date : "1970.01.01", text : "this is a placeholder&q

字段

原创 2023-06-21 00:06:57 40 阅读

查询聚类以及时间处理

SELECT COUNT(*), SUM(PKTS), SUM(BYTES) FROM mytableSELECT srcad, srcpo, dstad, dstpo, pro, COUNT(*), SUM(PKTS), SUM(BYTES) FROM m

mongodb

原创 2023-06-21 00:06:54 77 阅读

Or 或操作

SELECT * FROM testWHERE (name LIKE '%star%' AND NOT name LIKE '%trek%') OR duration = 200db.test.find({$or: [ { name: /star/i, name: { $not: /trek/i } }, { duration: 200 } ...

clementine

原创 2023-06-21 00:06:48 58 阅读

或者和并且

case1 OR ( [case2 AND case3] OR [case4 AND case5] )You can try to use the $or operator:db.hg19_refgene_47.find({ $or: [ "_id.c" : 1, { "_id.p" : {"$gte" : 96978}, ...

hg

原创 2023-06-21 00:06:44 5325 阅读

设置数组中的值

{ _id: 1, name: 'John Smith', items: [{ id: 1, name: 'item 1', value: 'one' },{ id: 2, name: 'item 2', value: 'two' }]}Person.update({'items.i...

clementine

原创 2023-06-21 00:06:40 60 阅读

多个值的更新

{ "_id" : ObjectId("51596b7e469b9c3816000001"), "company" : { "_id" : "ade2fd0ec9b8b5e9152e0155", "title" : "LO3426546457" }

5e

原创 2023-06-21 00:06:37 50 阅读

分类查询

{ "_id" : ObjectId("515d8f53175b8ecb053425c2"), "category" : "Batteries", "products" : [ { "brand" : "Duracell", "item" : [

f5

原创 2023-06-21 00:06:34 30 阅读

删除文档中低于某个时间段的文档

if (doc.timestampField < older) { collection.remove(doc); } }) var older=Date.parse("2013-03-01"), all=collection.find();all.forEach(function(doc) { var ts = doc._id.getTimestamp(); if ...

clementine

原创 2023-06-21 00:06:31 47 阅读

只显示文档中所有的特定字段

{ "_id": { "$id": "515bb7e2a00b2add0b000001" }, "user_id": "user_8888", "events": { "common test I": { "subject": "comm

clementine

原创 2023-06-21 00:06:24 47 阅读

在数组中的数组添加内容

{ "_id" : ObjectId("5188c93f0361ca6dc33e3a30"), "admin" : [ ], "created" : "2013-04-30 19:10:21", "description" : "guitar theory", "mem

Test

ios

原创 2023-06-21 00:06:20 54 阅读

$cond统计个数

{ $cond: [ <boolean-expression>, <true-case>, <false-case> ] }db.activity.insert({"userUrl": "http://news.bbc.co.uk", "userAddress" : "1.2.3.4", "requestTime" :

clementine

原创 2023-06-21 00:05:59 68 阅读

排除null或者“”

db.images.distinct( "gallery" , { "gallery" : { $nin : ["", null] } });

clementine

原创 2023-06-21 00:05:20 91 阅读

更新权限

> db.users.findOne(){ "_id" : ObjectId("51e3e2e16a847147f7ccdf7d"), "user" : "testAdmin", "pwd" : "[some hash]", "roles" : [ "clusterAdmin&quo

clementine

原创 2023-06-21 00:05:04 45 阅读

更新数组中的一个值

{ students: [ { name: "john", school: 102, age: 4 }, { name: "jess", school: 102, age: 11 }, { name: "jeff", school: 108, age: 7 } ]}{...

数据库

ajax

原创 2023-06-21 00:04:59 66 阅读

统计两个和的和

{ "$project" : { 'totalA' : '$totalA', 'totalB' : '$totalB', 'totalSum' : { '$add' : [ '$totalA', '$totalB' ] }, }

clementine

原创 2023-06-21 00:04:54 46 阅读

统计数组中某个属性的个数

{ attrib : [ { k: "color", v: "red" }, { k: "shape", v: "rectangle" }, { k: "color", v: "blue" }, { k: "avail", v: true } ]}统计 color

2d

原创 2023-06-21 00:04:46 110 阅读

统计条件查询

if amount < 0, then 0 - amount else { $project: { amount: { $cond: [ { $lt: ['$amount', 0] }, { $subtract: [0, '$amount'] }, '$amount' ]}}}

clementine

原创 2023-06-21 00:04:42 35 阅读

删除多个数据

db.collection.remove( { _id : { $in: [ ObjectId("51ee3966e4b056fe8f074f48"), ObjectId("51ee3966e4b056fe8f074f4a"), ObjectId("51ee3966e4b056fe8f074f4b") ] } } );

clementine

原创 2023-06-21 00:04:38 74 阅读

统计数组个数并且把统计的放入一个数组中

{queid:'1',date:'07023/2013',topic: 'topic1'}{queid:'2',date:'07022/2013',topic: 'topic2'}{queid:'3',date:'07022/2013',topic: 'topic1'}{queid:'4',date:'07023/2013',topic: 'topic1'}que.agg...

clementine

原创 2023-06-21 00:04:34 219 阅读

重复的只取第一个

{ num: 4, title: "alpha", data: 7538 }{ num: 2, title: "beta", data: 7538 }{ num: 7, title: "beta", data: 7538 }{ num: 5, title: "alpha", data: 7538 }希望{ num: 2, title: "beta", data: 7538...

clementine

原创 2023-06-21 00:04:25 223 阅读

改名重新归类统计

{ account:"abc", vendor:"amazon",} ...{ account:"abc", vendor:"overstock",}想得到{ account:"abc", vendorCount:2}b.collection.aggregate([{ $group: { _id: { account: '...

bc

原创 2023-06-21 00:03:58 82 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

mb649166f4c151e的博客