设为首页 加入收藏

TOP

Mongodb-基本命令(二)
2015-11-21 01:54:07 来源: 作者: 【 】 浏览:1
Tags:Mongodb- 基本 命令
16 } { "_id" : ObjectId("55bec43732cbb5faa25c967d"), "name" : "yuan", "age" : "23" } >

?

7.3 向集合中的某个文档添加字段 push

?

> db.LABELNET.update({"name":"yuan"},{$push:{"csdnBlog":"http://blog.csdn.net/la
blenet"}});
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.LABELNET.find();
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
{ "_id" : ObjectId("55bec43732cbb5faa25c967d"), "name" : "yuan", "age" : "23", "
csdnBlog" : [ "http://blog.csdn.net/lablenet" ] }
>

?

8.删除操作 remove

8.1 基本格式

?

(1)db.集合名称.remove(where); 条件删除

(2) db.集合名称.remove(); 删除全部记录

(3) db.集合名称.drop(); 删除全部文档(document)


8.2 演示示例 :条件删除

?

> db.LABELNET.remove({"name":"yuan"});
WriteResult({ "nRemoved" : 1 })
> db.LABELNET.find();
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
>

?

9. 其他操作

9.1 先准备数据

?

> db.LABELNET.insert({"name":"yuan","age":23});
WriteResult({ "nInserted" : 1 })
> db.LABELNET.insert({"name":"ming","age":10});
WriteResult({ "nInserted" : 1 })
> db.LABELNET.insert({"name":"zhuo","age":30});
WriteResult({ "nInserted" : 1 })
> db.LABELNET.insert({"name":"hpu","age":30});
WriteResult({ "nInserted" : 1 })
> db.LABELNET.find();
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
{ "_id" : ObjectId("55beca3932cbb5faa25c967e"), "name" : "yuan", "age" : 23 }
{ "_id" : ObjectId("55beca4632cbb5faa25c967f"), "name" : "ming", "age" : 10 }
{ "_id" : ObjectId("55beca5132cbb5faa25c9680"), "name" : "zhuo", "age" : 30 }
{ "_id" : ObjectId("55beca9f32cbb5faa25c9681"), "name" : "hpu", "age" : 30 }
>


?

9.1 条件查询 —— > , < , >= ,<=

?

?

(1) (>) 大于 - $gt

(2)(<) 小于 - $lt

(3)(>=) 大于等于 - $gte

(4)(<= ) 小于等于 - $lte

> db.LABELNET.find({"age":{"$gt":16}});
{ "_id" : ObjectId("55beca3932cbb5faa25c967e"), "name" : "yuan", "age" : 23 }
{ "_id" : ObjectId("55beca5132cbb5faa25c9680"), "name" : "zhuo", "age" : 30 }
{ "_id" : ObjectId("55beca9f32cbb5faa25c9681"), "name" : "hpu", "age" : 30 }
> db.LABELNET.find({"age":{"$lt":16}});
{ "_id" : ObjectId("55beca4632cbb5faa25c967f"), "name" : "ming", "age" : 10 }
> db.LABELNET.find({"age":{"$gte":16}});
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
{ "_id" : ObjectId("55beca3932cbb5faa25c967e"), "name" : "yuan", "age" : 23 }
{ "_id" : ObjectId("55beca5132cbb5faa25c9680"), "name" : "zhuo", "age" : 30 }
{ "_id" : ObjectId("55beca9f32cbb5faa25c9681"), "name" : "hpu", "age" : 30 }
> db.LABELNET.find({"age":{"$lte":16}});
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
{ "_id" : ObjectId("55beca4632cbb5faa25c967f"), "name" : "ming", "age" : 10 }
> db.LABELNET.find({"age":16});
{ "_id" : ObjectId("55bec40532cbb5faa25c967c"), "name" : "csdn", "age" : 16 }
>

9.2 满足条件的条数 count

?

> db.LABELNET.count({"age":30});
2
>

9.3 得到所有key的value(去掉重复的) distinct

?

?

> db.LABELNET.distinct("age");
[ 16, 23, 10, 30 ]
>

9.4 查看集合的数据大小 dataSize : 注意S 大写

?

?

> db.LABELNET.dataSize();
560
>

9.5 查看集合状态 stats

?

?

> db.LABELNET.stats();
{
        "ns" : "student.LABELNET",
        "count" : 5,
        "size" : 560,
        "avgObjSize" : 112,
        "numExtents" : 1,
        "storageSize" : 8192,
        "lastExtentSize" : 8192,
        "paddingFactor" : 1,
        "paddingFactorNote" : "paddingFactor is unused and unmaintained in 3.0.
It remains hard coded to 1.0 for compatibility only
首页 上一页 1 2 3 4 下一页 尾页 2/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇【翻译自mos文章】使用config.sh/.. 下一篇Oracle学习(5):多表查询

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: