Chinaunix首页 | 论坛 | 博客
  • 博客访问: 204125
  • 博文数量: 45
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 444
  • 用 户 组: 普通用户
  • 注册时间: 2014-03-11 12:23
文章分类

全部博文(45)

文章存档

2017年(1)

2016年(14)

2014年(30)

我的朋友

分类: Mysql/postgreSQL

2016-08-29 22:25:40

  • > db.per.find({$and:[{age:{$gt:5}},{age:{$lt:10}}]})//age大于5且小于10
    { "_id" : 6, "name" : "liu_6", "age" : 6 }
    { "_id" : 7, "name" : "liu_7", "age" : 7 }
    { "_id" : 8, "name" : "liu_8", "age" : 8 }
    { "_id" : 9, "name" : "liu_9", "age" : 9 }


  • > db.per.find({$nor:[{age:2}],$and:[{age:{$lt:5}}]});//age不等于2且小于5
    { "_id" : 0, "name" : "liu", "age" : 0, "addr" : [ "bj" ] }
    { "_id" : 1, "name" : "liu_1", "age" : 1 }
    { "_id" : 3, "name" : "liu_3", "age" : 3 }
    { "_id" : 4, "name" : "liu_4", "age" : 4 }


  • > db.per.find({addr:{$exists:1}});//是否存在
    { "_id" : 0, "name" : "liu", "age" : 0, "addr" : [ "bj" ] }
  • db.per.insert({lili:hobby['a','b','c']});
    db.per.insert({lucy:hobby['b','c','d']});
    db.per.find({$all:{hobby:['b','c']}});


  • $gt >
  •  $gte >=
  •  $lt <
  •  $lte <=
  •  $in in
  •  $ne !=
  •  $nin not in


   for(var i=0;i<10000;i++){
        db.bar.insert({'_id':i+1,title:'aaa'+i})
    }

    var cursor = db.bar.find();
     cursor.next();

    
> var cur = db.per.find({age:{$lt:5}})
> printjson(cur.next());
{ "_id" : 0, "name" : "liu", "age" : 0, "addr" : [ "bj" ] }
> printjson(cur.next());
{ "_id" : 1, "name" : "liu_1", "age" : 1 }


用循环来打印
var cur = db.find({age:{$lt:5}});
while(cur.hasNext()){

     printjson(cur.next());

}


//forEach
> var cur = db.per.find({age:{$lt:5}});
> cur.forEach(function(obj){printjson(obj)});
{ "_id" : 0, "name" : "liu", "age" : 0, "addr" : [ "bj" ] }
{ "_id" : 1, "name" : "liu_1", "age" : 1 }
{ "_id" : 2, "name" : "liu_2", "age" : 2 }
{ "_id" : 3, "name" : "liu_3", "age" : 3 }
{ "_id" : 4, "name" : "liu_4", "age" : 4 }











阅读(1363) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~