日期:2014-05-16 浏览次数:20537 次
查看命令的方式:
1.在shell中运行db.listCommands()
2.在浏览器中访问管理员接口:http://ipaddress:28017/_commands
?
下面介绍在Mongodb中最经常使用的命令,具体如下:
命令:buildInfo
格式:{"buildInfo":1}
介绍:管理专用命令,返回Mongodb服务器的版本号和主机的操作系统。
示例:
> db.runCommand({"buildInfo":1})
{
"version" : "2.0.6",
"gitVersion" : "e1c0cbc25863f6356aa4e31375add7bb49fb05bc",
"sysInfo" : "Linux domU-12-31-39-01-70-B4 2.6.21.7-2.fc8xen #1 SMP Fri Feb 15 12:39:36 EST 2008 i686 BOOST_LIB_VERSION=1_41",
"versionArray" : [
2,
0,
6,
0
],
"bits" : 32,
"debug" : false,
"maxBsonObjectSize" : 16777216,
"ok" : 1
}
命令:collStats
格式:{"collStats":collection}
介绍:返回指定集合的统计信息,包括数据大小、已分配的存储空间和索引的大小。
示例:
> db.runCommand({"collStats":"users"})
{
"ns" : "test.users",
"count" : 3,
"size" : 508,
"avgObjSize" : 169.33333333333334,
"storageSize" : 4096,
"numExtents" : 1,
"nindexes" : 2,
"lastExtentSize" : 4096,
"paddingFactor" : 1.51,
"flags" : 0,
"totalIndexSize" : 16352,
"indexSizes" : {
"_id_" : 8176,
"name_1" : 8176
},
"ok" : 1
}
命令:distinct
格式:{"distinct":collection,"key":key,"query":query}
介绍:列出指定集合中满足查询条件的文档的指定键的所有不同值
示例:?
> db.runCommand({"distinct":"foo","key":"name","query":{"age":{"$gt":20}}})
{
"values" : [
"gongyong",
"chenzhou",
"yixin"
],
"stats" : {
"n" : 4,
"nscanned" : 6,
"nscannedObjects" : 6,
"timems" : 50,
"cursor" : "BasicCursor"
},
"ok" : 1
}
命令:drop
格式:{"drop":collection}
介绍:删除集合的所有数据
示例:?
> db.bbb.save({"x":1,"y":2})
#先往bbb中存一条记录
> db.bbb.find() #查询bbb中的数据
{ "_id" : ObjectId("5027d919831a10b0f6e61385"), "x" : 1, "y" : 2 }
#使用drop命令删除bbb集合中的数据
> db.runCommand({"drop":"bbb"})
{
"nIndexesWas" : 1,
"msg" : "indexes dropped for collection",
"ns" : "test.bbb",
"ok" : 1
}
> db.bbb.find() #再次查询,结果为空
命令:dropDatabase
格式:{"dropDatabase":1}
介绍:删除当前数据库中的所有数据
示例:略
?
命令:dropIndexes
格式:{"dropIndexes":collection,"index":name}
介绍:删除集合里面名称为name的索引,如果名称为"*",则删除全部索引。
示例:
> db.system.indexes.find()
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.foo", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.users", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.games", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.blog.post", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.lists", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.math", "name" : "_id_" }
{ "v" : 1, "key" : { "name" : 1 }, "ns" : "test.users", "name" : "name_1" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.map", "name" : "_id_" }
{ "v" : 1, "key" : { "gps" : "2d" }, "ns" : "test.map", "name" : "gps_", "min" : -180, "max" : 181 }
> db.runCommand({"dropIndexes":"users","index":"name_1"})
{ "nIndexesWas" : 2, "ok" : 1 }
> db.system.indexes.find()
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.foo", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.users", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.games", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.blog.post", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.lists", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.math", "name" : "_id_" }
{ "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.map", "name" : "_id_" }
{ "v" : 1, "key" : { "gps" : "2d" }, "ns" : "test.map", "name" : "gps_", "min" : -180, "max" : 181 }
命令:findAndModify
格式:
介绍:查找并修改
示例:?