连接远程数据库:
./mongo 127.0.0.1:27017/test
-----------------------------------------------------
显示所以数据库:
show dbs
-----------------------------------------------------
选择数据库:
use DbName
-----------------------------------------------------
显示当前库的所以集合:
show collections
-----------------------------------------------------
查询多条语句:
db.CollName.find()
-----------------------------------------------------
查询一条语句:
db.CollName.findOne()
-----------------------------------------------------
用户认证:
use admin;
db.auth('admin', 'password');
-----------------------------------------------------
创建固定空间集合
db.createCollection('sleuth', {'size': 644245094400})
-----------------------------------------------------
插入数据:
post = { "title": "this is title", "content": "this is content", "date": new Date() };
db.blog.insert(post);
-----------------------------------------------------
更新一条符合条件的数据:
post.title = "this is update one title";
db.blog.update({ "title": "this is title"}, post);
-----------------------------------------------------
更新所以符合条件的数据:
post.title = "this is update all title";
db.blog.update({ "title": "this is title"}, {$set: post}, false, true);
-----------------------------------------------------
保存修改后的数据
var data = db.blog.findOne();
data.title = "update data";
db.blog.save(data);
-----------------------------------------------------
查询后更新:
db.blog.findAndModify({
"query": {"title": "old title"},
"sort": {"date": -1},
"update": {"title": "new title"}
});
-----------------------------------------------------
修改器关键词:
$set(指定一个键的值,不存在就添加), $unset(), $inc(字数累加), $push(数组末尾加入), $pop(数组头部删除一个), $pull(数组删除指定内容), $addToSet, $each,
-----------------------------------------------------
查询器关键词:
$or, $in, $nin, $not, $exists(键存在)
-----------------------------------------------------
比较符:
不等于:$ne
小于:$lt
大于:$gt
小于或等于:$lte
大于或等于:$gte
-----------------------------------------------------
$in, $nin用法:
db.blog.find({"author_id": {"$in": [1,2,3,4]}});
-----------------------------------------------------
$exists用法:
db.blog.find({"
-----------------------------------------------------
查询后更新:
db.blog.findAndModify({
"query": {"title": "old title"},
"sort": {"date": -1},
"update": {"title": "new title"}
});
-----------------------------------------------------
将普通集合更改为固定空间集合
db.runCommand({"convertToCapped":"sleuth", "size":644245094400});
###############################
-----------------------------------------------------
获取活动列表:
db.currentOp();
-----------------------------------------------------
关闭某一活动:
db.killOp(OpId);
###############################