mongoDB 入门指南、示例（转）
一、准备工作
1、 下载mongoDB
下载地址：http://www.mongodb.org/downloads
选择合适你的版本
相关文档：http://www.mongodb.org/display/DOCS/Tutorial
2、 安装mongoDB
A、 不解压模式：
将 下载下来的mongoDB-xxx.zip打开，找到bin目录，运行mongod.exe就可以启动服务，默认端口27017，db保存的路径是系统C 硬盘目录的根目录的/data/db目录。也就是说，如果你的mongoDB-xxx.zip在E盘，那么你需要在C盘下建立data/db目录。 mongoDB不会帮你建立这个目录的。
然后运行mongo即可连接到test数据库，你就可以进行数据操作。运行help显示帮助命令行。
B、 解压模式
将 下载下来的mongoDB-xxx.zip解压到任意目录，找到bin目录，运行mongod.exe就可以启动mongoDB，默认端口 27017，db保存的路径是当前zip所在硬盘目录的根目录的/data/db目录。也就是说，如果你的mongoDB-xxx.zip在E盘，那么你 需要在E盘下建立data/db目录。mongoDB不会帮你建立这个目录的。
然后运行mongo即可连接到test数据库，你就可以进行数据操作。运行help显示帮助命令行。
3、 简单测试
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]> db[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]test[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]> [/size][size=10.0pt; font-family: 'Courier New'; color: green;" lang="EN-US]//[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: green;]第一次插入数据会创建数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]Fri May 20 16:47:39 malformed UTF-8 character sequence at offset 27[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]error2:(shellhelp1) exec failed: malformed UTF-8 character sequence at offset 27[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]> db.foo.insert({id: 2011, userName: [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]'hoojo'[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US], age: 24, email: [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"hoojo_@126.com"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]> db.foo.find();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]{ [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"_id"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] : ObjectId([/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"4dd62b0352a70cbe79e04f81"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]), [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"id"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] : 2011, [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"userName"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] : [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"hoojo"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US],[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"age"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] : 24, [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"email"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] : [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]"hoojo_@126.com"[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] }[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]> [/size]
上面完成了简单运算，显示当前使用的数据库，以及添加数据、查询数据操作
?
二、DB shell数据操作
shell命令操作语法和JavaScript很类似，其实控制台底层的查询语句都是用JavaScript脚本完成操作的。
? 数据库
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]Help[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]查看命令提示[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]help[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].help[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].yourColl.help[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].youColl.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].help[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]rs[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].help[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、切换[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]/[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]创建数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>use yourDB;[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]当创建一个集合[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]table[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US])[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的时候会自动创建当前数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: #006080;]、查询所有数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]show dbs;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除当前使用数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].dropDatabase[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、从指定主机上克隆数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].cloneDatabase[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](“127.0.0.1”);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]将指定机器上的数据库的数据克隆到当前数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、从指定的机器上复制指定数据库数据到某个数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].copyDatabase[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("mydb", "temp", "127.0.0.1");[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]将本机的[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]mydb[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的数据复制到[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]temp[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]数据库中[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]7[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、修复当前数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].repairDatabase[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]8[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查看当前使用的数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].getName[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US];[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]和[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]getName[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]方法是一样的效果，都可以查询当前使用的数据库[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]9[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、显示当前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]状态[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].stats[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]10[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、当前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]版本[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].version[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]11[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查看当前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的链接机器地址[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].getMongo[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
? Collection聚集集合
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、创建一个聚集集合（[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]table[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]）[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].createCollection[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](“collName”, {size: 20, capped: 5, max: 100});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、得到指定名称的聚集集合（[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]table[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]）[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].getCollection[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("account");[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、得到当前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的所有聚集集合[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].getCollectionNames[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、显示当前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]所有聚集索引的状态[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].printCollectionStats[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
? 用户相关
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、添加一个用户[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].addUser[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("name");[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].addUser[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("userName", "pwd123", true);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]添加用户、设置密码、是否只读[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、数据库认证、安全模式[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].auth[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("userName", "123123");[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: #006080;]、显示当前所有用户[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]show users;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除用户[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].removeUser[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("userName");[/size]
? 其他
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询之前的错误信息[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].getPrevError[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、清除错误记录[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].resetError[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
三、Collection聚集集合操作
? 查看聚集集合基本信息
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查看帮助[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].yourColl.help[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询当前集合的数据条数[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].yourColl.count[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查看数据空间大小[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.dataSize[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、得到当前聚集集合所在的[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.getDB[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、得到当前聚集的状态[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.stats[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、得到聚集集合总大小[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.totalSize[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]7[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、聚集集合储存空间大小[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.storageSize[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]8[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]Shard[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]版本信息[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.getShardVersion[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]9[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、聚集集合重命名[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.renameCollection[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("users");[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]将[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]userInfo[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]重命名为[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]users[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]10[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除当前聚集集合[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.drop[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
? 聚集集合查询
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询所有记录[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]* from userInfo;[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]默认每页显示[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]20[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]条记录，当显示不下的情况下，可以用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]it[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]迭代命令查询下一页数据。注意：键入[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]it[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]命令不能带[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]“[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]；[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]”[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]但是你可以设置每页显示数据的大小，用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]DBQuery[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].shellBatchSize[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 50;[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]这样每页就显示[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]50[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]条记录了。[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询去掉后的当前聚集集合中的某列的重复数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.distinct[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("name");[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]会过滤掉[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]中的相同数据[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: #006080;]：[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]select distict name from userInfo;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age = 22[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的记录[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({"age": 22});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 22;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] 22[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的记录[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$gt: 22}});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]22;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$lt: 22}});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]= 25[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的记录[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$gte: 25}});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>= 25;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]7[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$lte: 25}});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]8[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]= 23 [/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]并且[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$gte: 23, $lte: 26}});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]9[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]中包含[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] mongo[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: /mongo/});[/size]
[size=10.0pt; font-family: 'Courier New'; color: green;" lang="EN-US]//[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: green;]相当于[/size][size=10.0pt; font-family: 'Courier New'; color: green;" lang="EN-US]%%[/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where name like ‘%mongo%’;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]10[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]中以[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]mongo[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]开头的[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: /^mongo/});[/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where name like ‘mongo%’;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]11[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询指定列[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({}, {name: 1, age: 1});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: #006080;]：[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]select name, age from userInfo;[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]当然[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]也可以用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]true[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]或[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]false,[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]当用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]ture[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的情况下河[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name:1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]效果一样，如果用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]false[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]就是排除[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]，显示[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]以外的列信息。[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]12[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询指定列[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]数据[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US], age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] 25[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$gt: 25}}, {name: 1, age: 1});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] name, age from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]25;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]13[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、按照年龄排序[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]升序：[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].sort[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: 1});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]降序：[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].sort[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: -1});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]14[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]name = zhangsan, age = 22[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: 'zhangsan', age: 22});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where name = ‘zhangsan’ and age = ‘22’;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]15[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询前[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]条数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].limit[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](5);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]top[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] 5 [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]* from userInfo;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]16[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]10[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]条以后的数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].skip[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](10);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where id not in ([/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]top[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] 10 * from userInfo[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]);[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]17[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询在[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5-10[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]之间的数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].limit[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](10)[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].skip[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](5);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]可用于分页，[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]limit[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]是[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]pageSize[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]，[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]skip[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]是第几页[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]*pageSize[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]18[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]or[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]与[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]查询[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({$or: [{age: 22}, {age: 25}]});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] * from userInfo where age = 22 or age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 25;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]19[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询第一条数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.findOne[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]top[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] 1 [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]* from userInfo;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].limit[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](1);[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]20[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询某个结果集的记录条数[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$gte: 25}})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].count[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] count(*) from userInfo where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>= 20;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]21[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、按照某列进行排序[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({sex: {$exists: true}})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].count[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]select[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] count(sex[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]) from userInfo;[/size]
? 索引
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、创建索引[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.ensureIndex[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: 1});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.ensureIndex[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: 1, ts: -1});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询当前聚集集合所有索引[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.getIndexes[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查看总索引记录大小[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].userInfo.totalIndexSize[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、读取当前集合的所有[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]index[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]信息[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.reIndex[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除指定索引[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.dropIndex[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]("name_1");[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除所有索引索引[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.dropIndexes[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
? 修改、添加、删除集合数据
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、添加[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.save[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: ‘zhangsan’, age: 25, sex: true});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]添加的数据的数据列，没有固定，根据添加的数据为准[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、修改[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.update[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: 25}, {$set: {name: 'changeName'}}, false, true);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]update users set name = ‘changeName’ where age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 25;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.update[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: 'Lisi'}, {$inc: {age: 50}}, false, true);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]update users set age = age + 50 where name = ‘Lisi’;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.update[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: 'Lisi'}, {$inc: {age: 50}, $set: {name: 'hoho'}}, false, true);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]相当于：[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]update users set age = age + 50, name = ‘hoho’ where name = ‘Lisi’;[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、删除[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.remove[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: 132});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、查询修改删除[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.findAndModify[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]query: {age: {$gte: 25}},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]sort: {age: -1},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]update: {$set: {name: 'a2'}, $inc: {age: 2}},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]remove: true
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].runCommand[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({ findandmodify : "users", [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]query: {age: {$gte: 25}},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]sort: {age: -1},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]update: {$set: {name: 'a2'}, $inc: {age: 2}},
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]remove: true
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]});[/size]
update或 remove其中一个是必须的参数; 其他参数可选。
参数
详解
默认值
query
查询过滤条件
{}
sort
如果多个文档符合查询过滤条件，将以该参数指定的排列方式选择出排在首位的对象，该对象将被操作
{}
remove
若为true，被选中对象将在返回前被删除
N/A
update
一个 修改器对象
N/A
new
若为true，将返回修改后的对象而不是原始对象。在删除操作中，该参数被忽略。
false
fields
参见Retrieving a Subset of Fields (1.5.0+)
All fields
upsert
创建新对象若查询结果为空。 示例 (1.5.4+)
false
? 语句块操作
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]1[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、简单[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]Hello World[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]print("Hello World!");[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]这种写法调用了[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]print[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]函数，和直接写入[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]"Hello World!"[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的效果是一样的；[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]2[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、将一个对象转换成[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]json[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]tojson(new Object());[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]tojson(new Object('a'));[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]3[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、循环添加数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] for ([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 0;[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]... db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.save[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({name: "u_" + [/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US], age: 22 + [/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US], sex: [/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] % 2});[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]... };[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]这样就循环添加了[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]30[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]条数据，同样也可以省略括号的写法[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] for ([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]= 0;[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]也是可以的，当你用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]查询的时候，显示多条数据而无法一页显示的情况下，可以用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]it[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]查看下一页的信息；[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]find [/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]游标查询[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] = db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] while ([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].hasNext[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()) { [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]??? [/size]printjson([size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].next[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()); [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]}[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]这样就查询所有的[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]users[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]信息，同样可以这样写[/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] = db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]while ([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].hasNext[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()) { printjson([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].next[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]); }[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]同样可以省略[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]{}[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]号[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]5[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]forEach[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]迭代循环[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].forEach[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](printjson);[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]forEach[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]中必须传递一个函数来处理每条迭代的数据信息[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]6[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、将[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]find[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]游标当数组处理[/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] = db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US][4];[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]取得下标索引为[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]4[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的那条数据[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]既然可以当做数组处理，那么就可以获得它的长度：[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].length[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]或者[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]cursor[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].count[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]那样我们也可以用循环显示数据[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]for ([/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] = 0, len = c[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].length[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](); [/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]i[/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]7[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、将[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]find[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]游标转换成数组[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: blue;" lang="EN-US]var[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] arr = db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]()[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].toArray[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]();[/size]
[size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]>[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] printjson(arr[2]);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]用[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]toArray[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]方法将其转换为数组[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]8[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、定制我们自己的查询结果[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]只显示[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age [/size][size=10.0pt; font-family: 'Courier New'; color: #006080;" lang="EN-US]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$lte: 28}}, {age: 1})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].forEach[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](printjson);[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$lte: 28}}, {age: true})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].forEach[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](printjson);[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]排除[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]age[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]的列[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].users.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({age: {$lte: 28}}, {age: false})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].forEach[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](printjson);[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US] [/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]9[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]、[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]forEach[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]传递函数显示信息[/size]
[size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]db[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].things.find[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]({x:4})[/size][size=10.0pt; font-family: 'Courier New'; color: #cc6633;" lang="EN-US].forEach[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US](function(x) {print(tojson(x));});[/size]
[size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]上面介绍过[/size][size=10.0pt; font-family: 'Courier New'; color: black;" lang="EN-US]forEach[/size][size=10.0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; color: black;]需要传递一个函数，函数会接受一个参数，就是当前循环的对象，然后在函数体重处理传入的参数信息。[/size]
?
