MongoDB的mongo shell常用操作方法及操作脚本笔记

1
2
3
4
5
6
7
8
9
help

db.help();

db.yourColl.help();

db.youColl.find().help();

rs.help();

1
show dbs;

1
db.dropDatabase();

1
db.cloneDatabase(“127.0.0.1”);

1
db.copyDatabase("mydb", "temp", "127.0.0.1");

1
db.repairDatabase();

1
db.getName();

1
db.stats();

1
db.version();

1
db.getMongo();

1
db.createCollection(“collName”, {size: 20, capped: 5, max: 100});//创建成功会显示{“ok”:1}

1
db.getCollection("account");

1
db.getCollectionNames();

1
db.printCollectionStats();

1
2
3
db.addUser("name");

db.addUser("userName", "pwd123", true);

1
show users;

1
db.removeUser("userName");

1
print("Hello World!");

1
2
3
tojson(new Object());

tojson(new Object('a'));

1
2
3
4
5
for (var i = 0; i < 30; i++) {

... db.users.save({name: "u_" + i, age: 22 + i, sex: i % 2});

... };

1
for (var i = 0; i < 30; i++) db.users.save({name: "u_" + i, age: 22 + i, sex: i % 2});

1
2
3
4
5
6
7
var cursor = db.users.find();

while (cursor.hasNext()) {

printjson(cursor.next());

}

1
2
3
var cursor = db.users.find();

while (cursor.hasNext()) { printjson(cursor.next); }

1
db.users.find().forEach(printjson);

1
2
3
var cursor = db.users.find();

cursor[4];

1
for (var i = 0, len = c.length(); i < len; i++) printjson(c[i]);

1
2
3
var arr = db.users.find().toArray();

printjson(arr[2]);

1
2
3
db.users.find({age: {$lte: 28}}, {age: 1}).forEach(printjson);

db.users.find({age: {$lte: 28}}, {age: true}).forEach(printjson);

1
db.users.find({age: {$lte: 28}}, {age: false}).forEach(printjson);

1
db.things.find({x:4}).forEach(function(x) {print(tojson(x));});

1
db.getPrevError();

1
db.resetError();

1
show dbs

1
show collections

1
show users