mongodb 命令

1.显示数据库

show dbs

2.创建数据库（要插入数据）

use  mall

3.创建一个集合（一张表）

db.goods.insert({id:101,name:'m12',salePrice:1222})

或是

db.createCollection('user')

4.查询当前集合

show collections

5.删除当前数据库

db.dropDatabase()

6.删除集合

db.user.drop()

7.当前数据库中的集合进行数据查找

db.foo.find()：
db.foo.find( { a : 1 } )：

db.userInfo.distinct("name");//查询去掉后的当前聚集集合中的某列的重复数据

db.userInfo.find({age: {$gt: 22}});//查询age > 22的记录   $lt，$gte，$lte

db.userInfo.find({age: {$gte: 23, $lte: 26}});

db.userInfo.find({name: /mongo/});   //查询name中包含 mongo的数据

db.userInfo.find({}, {name: 1, age: 1});//相当于：select name, age from userInfo;

db.userInfo.find({age: {$gt: 25}}, {name: 1, age: 1}); //相当于：select name, age from userInfo where age >25;

升序：db.userInfo.find().sort({age: 1});

降序：db.userInfo.find().sort({age: -1});

db.userInfo.find().limit(5);//查询前5条数据

db.userInfo.find().limit(10).skip(5);//查询在5-10之间的数据

db.userInfo.find({$or: [{age: 22}, {age: 25}]});//相当于：select * from userInfo where age = 22 or age = 25;

db.userInfo.find({age: {$gte: 25}}).count();//查询某个结果集的记录条数

8.查询第一条数据

db.userInfo.findOne();

9.增加数据

db.users.save({name: ‘zhangsan’, age: 25, sex: true});

10.修改

db.users.update({age: 25}, {$set: {name: 'changeName'}}, false, true);
相当于：update users set name = ‘changeName’ where age = 25;
 
db.users.update({name: 'Lisi'}, {$inc: {age: 50}}, false, true);
相当于：update users set age = age + 50 where name = ‘Lisi’;
 
db.users.update({name: 'Lisi'}, {$inc: {age: 50}, $set: {name: 'hoho'}}, false, true);
相当于：update users set age = age + 50, name = ‘hoho’ where name = ‘Lisi’;

11.删除

db.users.remove({age: 132});

12查询修改删除

db.users.findAndModify({
    query: {age: {$gte: 25}}, 
    sort: {age: -1}, 
    update: {$set: {name: 'a2'}, $inc: {age: 2}},
    remove: true
});
 
db.runCommand({ findandmodify : "users", 
    query: {age: {$gte: 25}}, 
    sort: {age: -1}, 
    update: {$set: {name: 'a2'}, $inc: {age: 2}},
    remove: true
});

索引

1、创建索引

db.userInfo.ensureIndex({name: 1});
db.userInfo.ensureIndex({name: 1, ts: -1});

2、查询当前聚集集合所有索引

db.userInfo.getIndexes();

3、查看总索引记录大小

db.userInfo.totalIndexSize();

4、读取当前集合的所有index信息

db.users.reIndex();

5、删除指定索引

db.users.dropIndex("name_1");

6、删除所有索引索引

db.users.dropIndexes();

导入数据

mongoimport -d mall  -c users  --file "C:UserszyDocumentsTencent Files532377209FileRecvdumall-users" 

https://www.cnblogs.com/xusir/archive/2012/12/24/2830957.html