MongoDB Common Commands

Super User-Related:

1. use admin
2. #增加或修改用户密码
3. db.adduser (Ixigua, ' pwd ')
4. #查看用户列表
5. db.system.users.find ()
6. #用户认证
7. Db.auth (Ixigua, ' pwd ')
8. #删除用户
9. db.removeuser (' MongoDB ')
10. #查看所有用户
11. Show Users
12. #查看所有数据库
13. show dbs
14. #查看所有的collection
15. Show Collections
16. #查看各collection的状态
17. D B.printcollectionstats ()
18. #查看主从复制状态
19. db.printreplicationinfo ()
20. #修复数据库
21. Db.repairdatabase ()
22. #设置记录profiling, 0=off 1=slow 2=all
23. db.setprofilinglevel (1)
24. # View Profiling
25. Show profile
26. #拷贝数据库
27. db.copydatabase (' mail_addr ', ' mail_addr_tmp ')
28. #删除collection
29. db.mail_addr.drop ()
30. #删除当前的数据库
31. db.dropdatabase ()

• Client connections
  1. /usr/local/mongodb/bin/mongo 8.8.88/ixigualib-u ixigua-p ' pwd '
• Delete and change
  1. #存储嵌套的对象
  2. Db.foo.save ({' name ': ' Ysz ', ' address ': {' city ': ' Beijing ', ' Post ': 100096}, ' phone ': [138,139]})
  3. #存储数组对象
  4. Db.user_addr.save ({' Uid ': ' [email protected] ', ' Al ': [' [email protected] ', ' [email protected] ']})
  5. #根据query条件修改, insert if not present, allow multiple records to be modified
  6. Db.foo.update ({' yy ': 5},{' $set ': {' xx ': 2}},upsert=true,multi=true)
  7. Records of #删除yy =5
  8. Db.foo.remove ({' yy ': 5})
  9. #删除所有的记录
  10. Db.foo.remove ()
• index  
  1. #增加索引: 1 (Ascending), -1 (Descending)
  2. Db.things.ensureIndex ({firstname:1, lastname:1}, {unique:true});
  3. #索引子对象
  4. Db.user_addr.ensureIndex ({' Al.em ': 1})
  5. #查看索引信息
  6. db.deliver_status.getIndexes ()
  7. db.deliver_status.getindexkeys ()
  8. #根据索引名删除索引
  9. db.user_ Addr.dropindex (' al.em_1 ')
• query  
  1. #查找所有
  2. db.foo.find ()
  3. #查找一条记录
  Li>db.foo.findone ()
  4. #根据条件检索10条记录
  5. db.foo.find ({' msg ': ' Hello 1 '}). Limit (Ten)
  6. #sort排序
  7. db.deliver_status.find ({' From ': ' [email protected] '}). Sort ({' Dt ', -1})
  8. Db.deliver_status.find (). Sort ({' Ct ': -1}). Limit (1)
  9. #count操作
  10. db.user_addr.count ()
  11. #distinct操作
  12. db.foo.distinct (' msg ')
  13. #> action
  14. Db.foo.find ({"timestamp": {"$gte": 2}})
  15. #子对象的查找
  16. db.foo.find ({' address.city ': ' Beijing '})
• Management
  1. #查看collection数据的大小
  2. Db.deliver_status.dataSize ()
  3. #查看colleciont状态
  4. Db.deliver_status.stats ()
  5. #查询所有索引的大小
  6. Db.deliver_status.totalIndexSize ()

MongoDB Common Commands