MongoDB的常用命令汇总(Mongo4.2.8)

>use “dbname”;

> show dbs;
mytest  0.000GB

> db.getName();

> db.version();

> db.getMonGo();

> db.createUser({user:"cg",pwd:"lianshi",roles:[{role:"readWrite",db:"mytest"}]})

db.updateUser("cg",{pwd:"123456"})

> db.auth("cg","lianshi");

> db.getCollectionNames();
[ "student" ]

db.student.insert({"id":"2","name":"yxy"})

> db.student.find();
{ "_id" : ObjectId("5eef61f3447efbc4346fbb9b"), "id" : "2", "name" : "yxy" }
{ "_id" : ObjectId("5eef61fe447efbc4346fbb9c"), "id" : "1", "name" : "hmf" }
{ "_id" : ObjectId("5eeff9582e8cdcf5c32c0ecf"), "id" : "3", "name" : "yx" }
相当于：select* from student;

> db.student.distinct("name");
[ "hmf", "yx", "yxy" ]

> db.student.find({"name":"yxy"});
{ "_id" : ObjectId("5eef61f3447efbc4346fbb9b"), "id" : "2", "name" : "yxy" }
{ "_id" : ObjectId("5ef077145c4ca32ccc787893"), "id" : "2", "name" : "yxy" }

db.student.insert({"id":NumberInt(1234567),"name":"hu"});

db.student.insert({"age":NumberLong(22),"name":"hu"});

db.student.insert({"va":NumberDecimal("22.3"),"name":"hu"});

db.student.find({})
   .projection({})
   .sort({_id:-1})
   .limit(100)

db.student.drop();