MongoDB 语法大全

江南西北 發表於 2023-6-21 16:57:00

<div id="content_views" class="markdown_views prism-atom-one-light">
 <svg xmlns="http://www.w3.org/2000/svg" style="display: none">
 <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0)"></path>
 </svg>
 
<div class="toc">
<h3>文章目录</h3>
<ul><li>前言</li><li><ul><li>MongoDB 语法大全</li><li><ul><li>01、mongodb 数据库链接</li><li>02、help查看命令提示</li><li>03、如果数据库存在，则切换到指定的数据库；如果数据库不存在，则创建数据库</li><li>04、查询所有的数据库</li><li>05、查看当前数据库</li><li><ul><li>05::01 查看当前数据库状态</li><li>05::02 查看当前数据库版本</li><li>05::03 查看当前数据库链接机器</li></ul>
</li><li>06、插入</li><li>07、查询</li><li><ul><li>07::01 查询</li><li>07::02 查询只返回一条数据</li><li>07::03 条件and查询</li><li>07::04 条件or查询</li><li>07::05 条件and 和 or 查询</li><li>07::06 条件操作符查询</li><li>07::07 模糊查询</li><li>07::08 $type 操作符查询</li><li>07::09 去重某列重复数据查询</li><li>07::10、in、not in 查询</li><li>07::11 指定字段返回</li></ul>
</li><li>08、排序</li><li><ul><li>08::01、升序</li><li>08::02、降序</li></ul>
</li><li>09、查询前3条数据</li><li>10、查询3条以后数据</li><li>11、分页</li><li>12、查询当前集合总数</li><li>13、删除当前数据库</li><li>14、新建集合</li><li>15、删除集合</li><li>16、获取当前db指定名称的聚集集合</li><li>17、获取当前db所有聚集集合</li><li>18、查询当前集合数量</li><li>19、查询当前集合的数据空间大小</li><li>20、查询当前集合总大小</li><li>21、查询当前集合存储空间大小</li><li>22、集合重命名</li><li>23、查询当前集合所在数据库</li><li>24、插入语法</li><li>25、修改</li><li><ul><li>25::01、修改集合中现有的文档</li><li>25::02、根据过滤器更新集合中的单个文档</li><li>25::03、更新与集合指定的筛选器匹配的所有文档</li></ul>
</li><li>26、删除</li><li>27、for循环</li><li>28、新建普通，复合，唯一索引、查询，删除索引</li><li>29、添加用户</li></ul>
</li></ul>
</li></ul>
</div>

<h1>前言</h1>
 如果您觉得有用的话，记得给博主点个赞，评论，收藏一键三连啊，写作不易啊^ _ ^。 而且听说点赞的人每天的运气都不会太差，实在白嫖的话，那欢迎常来啊!!!
<hr color="#000000" size="1"">
<h2>MongoDB 语法大全</h2>
<h3>01、mongodb 数据库链接</h3>
格式:mongodb:// host1[:port1][,host2[:port2],…[,hostN[:portN]]][/[?options]]
其中mongodb:// 是必须要有的。 username:password@ : -可选项如果设置，链接数据库服务后会尝试登录该数据库 database :-可选项如果指定username:password@ 链接验证指定数据库，不指定链接test数据库 options :链接选项，如果不使用database 前面需加上/，所有链接选项都是键值对name=value，多个选项时，以&或;分隔。
<h3>02、help查看命令提示</h3>
<pre data-index="0" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">help();
db.help();
db.新建集合.help();
例子:db.yangzhenyu.help();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/0833c8afe6ed4a70bbacb0c9e6890bb3.png" alt="在这里插入图片描述">
<h3>03、如果数据库存在，则切换到指定的数据库；如果数据库不存在，则创建数据库</h3>
<pre data-index="1" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">use 数据库名;
use yangzhenyu
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/7c48587544504686b8d2f4092cf774d2.png" alt="在这里插入图片描述">
<h3>04、查询所有的数据库</h3>
<pre data-index="2" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">// 01 插入一条数据，否则show dbs;不显示
db.yangzhenyu.insert({"name":"hello world!!!"});
// 02 查询所有数据库
show dbs;
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/7d99e324de30404e84c73d2e705a3104.png" alt="在这里插入图片描述">
<h3>05、查看当前数据库</h3>
<pre data-index="3" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db;或者 db.getName();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/c0357e3e754d4173814bf460bad06f72.png" alt="在这里插入图片描述">
<h4>05::01 查看当前数据库状态</h4>
<pre data-index="4" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.stats();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/06de43a50be74b4399a4fe6660c8aa9a.png" alt="在这里插入图片描述">
<h4>05::02 查看当前数据库版本</h4>
<pre data-index="5" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.version();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/0b31f58862494334ba692ec6ba510643.png" alt="在这里插入图片描述">
<h4>05::03 查看当前数据库链接机器</h4>
<pre data-index="6" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.getMongo();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/8b2491215766444f82c91056894c0184.png" alt="在这里插入图片描述">
<h3>06、插入</h3>
<pre data-index="7" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.insert();
在mongoDB中，不需要主动创建集合，当你插入文档时会自动创建
db.yangzhenyu.insert({"xxx":"yang","age":"27","yyy":"zhenyu"});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/96c789820f184464918f942a3b12a5e0.png" alt="在这里插入图片描述">
<h3>07、查询</h3>
<h4>07::01 查询</h4>
<pre data-index="8" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.find()
db.yangzhenyu.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/179ad3a1e6a84008bb1690bb9f027f11.png" alt="在这里插入图片描述">
<h4>07::02 查询只返回一条数据</h4>
<pre data-index="9" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.findOne();
db.yangzhenyu.findOne()
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/4cce3b7983c442d99d7c303d2e4d4f7f.png" alt="在这里插入图片描述">
<h4>07::03 条件and查询</h4>
<pre data-index="10" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.find({"key1":"name1","key2","name2"});
db.yangzhenyu.find({"xxx":"yang","age":"27"})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/b70f88943ae74bf7a1a5350584dc60e3.png" alt="在这里插入图片描述">
<h4>07::04 条件or查询</h4>
<pre data-index="11" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.find({
$or:[
 {"key1":"name1"},{"key2":"name2"}
]
})
db.yangzhenyu.find({ 
$or:[ 
{"name":"hello world!!!"}, {"age":"27"} 
] 
})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li><li style="color: rgba(153, 153, 153, 1)">9</li><li style="color: rgba(153, 153, 153, 1)">10</li><li style="color: rgba(153, 153, 153, 1)">11</li><li style="color: rgba(153, 153, 153, 1)">12</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/a5f95bf6097c48ca80e74848abf91d6a.png" alt="在这里插入图片描述">
<h4>07::05 条件and 和 or 查询</h4>
<pre data-index="12" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.find({
"key0":"name0",
$or:[
 {"key1":"name1"},{"key2":"name2"}
]
})
相当于: key0=name0 and (key1=name1 or key2=name2)
db.yangzhenyu.find({
"age":"27",
$or:[
{"name":"hello world!!!"}, {"age":"27"}
]
})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li><li style="color: rgba(153, 153, 153, 1)">9</li><li style="color: rgba(153, 153, 153, 1)">10</li><li style="color: rgba(153, 153, 153, 1)">11</li><li style="color: rgba(153, 153, 153, 1)">12</li><li style="color: rgba(153, 153, 153, 1)">13</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/c1de7624607f4079bf9170f172be18e0.png" alt="在这里插入图片描述">
<h4>07::06 条件操作符查询</h4>
<div class="table-box"><table><thead><tr><th></th><th></th><th></th></tr></thead><tbody><tr><td>></td><td>大于</td><td>$gt</td></tr><tr><td><</td><td>小于</td><td>$lt</td></tr><tr><td>>=</td><td>大于等于</td><td>$gte</td></tr><tr><td><=</td><td>小于等于</td><td>$lte</td></tr><tr><td>!=</td><td>不等于</td><td>$ne</td></tr></tbody></table></div>
<pre data-index="13" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yangzhenyu.find({
"age":{$gt:"26"}
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/0606f9676cb145a5a4fa140cabc92472.png" alt="在这里插入图片描述">
<h4>07::07 模糊查询</h4>
<pre data-index="14" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.find({"字段":/查询内容/});
// 模糊查询-包含2 
db.yangzhenyu.find({ 
"age":/2/ 
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/f513bbd76dea417ebc8ed267085280e7.png" alt="在这里插入图片描述">
<pre data-index="15" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">// 模糊查询-以2开头
db.yangzhenyu.find({
"age":/^2/
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/0da7c602125f405aa98aaa03df600c97.png" alt="在这里插入图片描述">
<pre data-index="16" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//模糊查询-小写kul
db.yangzhenyu.find({
"yyy":/kul/
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/a8605438a73c4db495e6333e9bbd7b86.png" alt="在这里插入图片描述">
<pre data-index="17" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//模糊查询-忽略大小写
db.yangzhenyu.find({
"yyy":/kul/i
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/3a7b1dfb55b0477f91982933ae40f414.png" alt="在这里插入图片描述">
<h4>07::08 $type 操作符查询</h4>
<pre data-index="18" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">$type操作符是基于BSON类型来检索集合中匹配的数据类型，并返回结果
准备:
创建集合typeTest，并插入两条数据
db.typeTest.insert({"name":"yangzhenyu","age":"27"});
db.typeTest.insert({"name":"yangzhenyu","age":27});
查询:
db.typeTest.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/c6d0d145941a40a3a60808ecd2d99303.png" alt="在这里插入图片描述">
<pre data-index="19" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询age字段为String的数据
db.yzyTest.find({"age":{
$type:'string'
}});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/b14bb450104b4e748e1114fc0a94d6a3.png" alt="在这里插入图片描述">
<pre data-index="20" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询age字段为int的数据
db.typeTest.find({"age":{
$type:'int'
}});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/638aef0dce7d4d08889ff8bcc0820515.png" alt="在这里插入图片描述">
<h4>07::09 去重某列重复数据查询</h4>
<pre data-index="21" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yangzhenyu.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/182078968a7b4a4c9dfdf3022e109677.png" alt="在这里插入图片描述">
<pre data-index="22" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">age字段去重查询:
db.yangzhenyu.distinct("age");
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/214d0839e6c74159aa1be2596a776a84.png" alt="在这里插入图片描述">
<h4>07::10、in、not in 查询</h4>
<pre data-index="23" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">in查询:
db.集合.find({
_id:{$in:["no1","no2"]}
});
not in 查询
db.集合.find({
_id:{$nin:["no1"]}
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li></ul></pre>
<h4>07::11 指定字段返回</h4>
<pre data-index="24" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzy.find({},{name:1});
db.集合.find(
query,
projection
)
projection: 指定返回字段
格式: {字段1:1,字段2:1}
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/79afe5d84f8340fdb779873e15041fd7.png" alt="在这里插入图片描述">
<h3>08、排序</h3>
<h4>08::01、升序</h4>
<pre data-index="25" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.sort({字段名:1})
db.yangzhenyu.find().sort({age:1})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/d617a37af1d842ad92cfb25307ccf917.png" alt="在这里插入图片描述">
<h4>08::02、降序</h4>
<pre data-index="26" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.sort({字段名:-1})
db.yangzhenyu.find().sort({age:-1})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/c9acbfceebb64b469403ebe244e20a6f.png" alt="在这里插入图片描述">
<h3>09、查询前3条数据</h3>
<pre data-index="27" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.limit(3);
db.yangzhenyu.find().limit(3);
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/bcf9099a6928409da2ac0c7e7181a9ef.png" alt="在这里插入图片描述">
<h3>10、查询3条以后数据</h3>
<pre data-index="28" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.skip(3);
db.yangzhenyu.find().skip(3);
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/2eac72cf4ab94b5c95154d53e032c60c.png" alt="在这里插入图片描述">
<h3>11、分页</h3>
<pre data-index="29" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.limit(pagesize).skip(第几页的pagesize);
//limit相当于pagesize skip相当于第几页的pagesize
1-3
db.yangzhenyu.find().limit(3).skip(0);
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/ec303ec569524a7d8d410ebb0657d193.png" alt="在这里插入图片描述">
<pre data-index="30" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">3-6
db.yangzhenyu.find().limit(3).skip(3);
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/09a1cd8d03144bbcac38c849a52f875d.png" alt="在这里插入图片描述">
<pre data-index="31" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">6-9
db.yangzhenyu.find().limit(3).skip(6);
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/f0ef2dcef0084f81bc61a490b05ece6f.png" alt="在这里插入图片描述"> 相当于mysql的limit函数
<h3>12、查询当前集合总数</h3>
<pre data-index="32" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">查询集合.count();
db.yangzhenyu.find().count();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/5d7ec70e6ec94f17848878136348c60b.png" alt="在这里插入图片描述">
<h3>13、删除当前数据库</h3>
<pre data-index="33" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.dropDatabase();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<h3>14、新建集合</h3>
<pre data-index="34" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//创建固定集合
db.createCollection("yzyTest",{
capped:true,size:6142800,max:1000
}); 
capped - 如果为true，则创建固定集合。固定集合是指有着固定大小的集合，当达到最大值，会自动覆盖最早的文档，当值为true时，必须指定size参数。 
size - 为固定集合指定一个最大值，即字节数。 
max - 指定固定集合中包含文档的最大数量。 
注:在插入文档时，mongoDB首先检查固定集合的size字段，然后检查max字段。 
//查看已有集合 
show collections;
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li><li style="color: rgba(153, 153, 153, 1)">9</li><li style="color: rgba(153, 153, 153, 1)">10</li><li style="color: rgba(153, 153, 153, 1)">11</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/9900a4746f8e4485b85247e48731d598.png" alt="在这里插入图片描述">
<pre data-index="35" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//在mongoDB中，不需要主动创建，当你插入文档时会自动创建
db.yzyTest1.insert({"name":"yangzhenyu","age":"27"})
//查看已有集合
show collections;
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/3111bd62f9ea4b47b4c770d33c4cf159.png" alt="在这里插入图片描述">
<h3>15、删除集合</h3>
<pre data-index="36" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.drop();
db.yzyTest1.drop();
//查看已有集合
show collections;
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/24412d7ae63546b0a1116481a5c4e929.png" alt="在这里插入图片描述">
<h3>16、获取当前db指定名称的聚集集合</h3>
<pre data-index="37" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.getCollection("yzyTest");
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/374377294030447c97f023848efcc1fd.png" alt="在这里插入图片描述">
<h3>17、获取当前db所有聚集集合</h3>
<pre data-index="38" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.getCollectionNames();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/3b9d90557ce940049db5c7a865622bdf.png" alt="在这里插入图片描述">
<h3>18、查询当前集合数量</h3>
<pre data-index="39" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyTest.count();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/9fb2d854a19c4538a855900277399891.png" alt="在这里插入图片描述">
<h3>19、查询当前集合的数据空间大小</h3>
<pre data-index="40" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyTest.dataSize();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/064de0bec65d483e98f026f3892f7d5f.png" alt="在这里插入图片描述">
<h3>20、查询当前集合总大小</h3>
<pre data-index="41" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyTest.totalSize();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/4a98208e90be4fd68ba6c972009f6fbe.png" alt="在这里插入图片描述">
<h3>21、查询当前集合存储空间大小</h3>
<pre data-index="42" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyTest.storageSize();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/4fc2b9e3395d4b7f91de24d3291c312d.png" alt="在这里插入图片描述">
<h3>22、集合重命名</h3>
<pre data-index="43" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyTest.renameCollection("yzyRenameTest");
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/797a1e777ac8452a827312c120f7d3db.png" alt="在这里插入图片描述">
<pre data-index="44" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">show collections;
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/32bf2cc411f7468b8fd364679b7420d2.png" alt="在这里插入图片描述">
<h3>23、查询当前集合所在数据库</h3>
<pre data-index="45" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzyRenameTest.getDB();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/4374cfb0553e48fe90caef1ae7a65b0d.png" alt="在这里插入图片描述">
<h3>24、插入语法</h3>
<pre data-index="46" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//插入一条数据
db.集合.insertOne({_id:"01",name:"yang",age:"12"});
//插入多条
db.集合.insertMany([{_id:"02",name:"yang",age:"12"},{_id:"03",name:"yang",age:"12"}])
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li></ul></pre>
<h3>25、修改</h3>
<h4>25::01、修改集合中现有的文档</h4>
<pre data-index="47" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.集合.update(
<query>,
<update>
)
query:update的查询条件，即where后的语句条件;
update: 更新值，也可理解为sql update中set后面的语句;
注:默认只更新找到的第一条；
例子: 
db.yzy.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li><li style="color: rgba(153, 153, 153, 1)">9</li><li style="color: rgba(153, 153, 153, 1)">10</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/a9a992cd537e453bbb3eb22bdd458c34.png" alt="在这里插入图片描述">
<pre data-index="48" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//只更新找到的第一条
db.yzy.update({age:"12"},{$set:{age:"13"}});
db.yzy.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/5dfa40b620c24779856a2f3a214d6c64.png" alt="在这里插入图片描述">
<h4>25::02、根据过滤器更新集合中的单个文档</h4>
实例: db.yzy.find(); <img src="https://img-blog.csdnimg.cn/4cdd6a7d4457445b9d56c99b154ef355.png" alt="在这里插入图片描述">
<pre data-index="49" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzy.updateOne({age:"12"},{$set:{age:"13"}});
db.yzy.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/02901778e54242e4b3cec2080ec08899.png" alt="在这里插入图片描述">
<h4>25::03、更新与集合指定的筛选器匹配的所有文档</h4>
<pre data-index="50" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzy.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/9dbfe9d90705403a8706825e07a84ffb.png" alt="在这里插入图片描述">
<pre data-index="51" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzy.updateMany({age:"12"},{$set:{age:"13"}});
db.yzy.find();
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/59656ba7112e41d3a0bccaea3b6debff.png" alt="在这里插入图片描述">
<h3>26、删除</h3>
<pre data-index="52" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">从集合中删除单个文档
db.yzy.deleteOne({age:"13"})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/dd40d4cf088841eb8382652cd729ca4d.png" alt="在这里插入图片描述">
<pre data-index="53" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">从集合中删除与筛选器匹配的所有文档
db.yzy.deleteMany({age:"13"})
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li></ul></pre>
<img src="https://img-blog.csdnimg.cn/6c0b8abdff304943b94bfc9c7bfa9478.png" alt="在这里插入图片描述">
<h3>27、for循环</h3>
<pre data-index="54" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.yzy.find().forEach(
function(item){
 if(item.age >= 12){
 db.yzy.updateOne({age:item.age},{$set:{age:"13"}});
 }
}
)
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li></ul></pre>
<h3>28、新建普通，复合，唯一索引、查询，删除索引</h3>
<pre data-index="55" class="set-code-hide prettyprint"><code class="prism language-bash has-numbering" style="position: unset">//查询当前db所有聚集索引
db.printCollectionStats();
//创建普通索引
//db.集合.ensureIndex({字段名:1}) 1表示升序、-1表示降序升序、降序对单索引没有影响，对复合索引有影响
db.yzy.ensureIndex({"name":1});
//创建复合索引 
//db.集合.ensureIndex({字段1名:1,字段2名:1}) 
db.yzy.ensureIndex({"name":1,"age":1});
//创建唯一索引 
//db.集合.ensureIndex({字段名:1}) 1表示升序、-1表示降序 
db.yzy.ensureIndex({"age":1},{"unique":true});
//删除索引 
//db.集合.dropIndex({字段名:1}); 
db.yzy.dropIndex({"name":1});
//查询当前集合所有索引 
//db.集合.getIndexes() 
db.yzy.getIndexes();
<div class="hljs-button {2}" data-title="复制"></div></code><div class="hide-preCode-box"><img class="look-more-preCode contentImg-no-view" src="https://csdnimg.cn/release/blogv2/dist/pc/img/newCodeMoreWhite.png" alt="" title=""></div><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li><li style="color: rgba(153, 153, 153, 1)">6</li><li style="color: rgba(153, 153, 153, 1)">7</li><li style="color: rgba(153, 153, 153, 1)">8</li><li style="color: rgba(153, 153, 153, 1)">9</li><li style="color: rgba(153, 153, 153, 1)">10</li><li style="color: rgba(153, 153, 153, 1)">11</li><li style="color: rgba(153, 153, 153, 1)">12</li><li style="color: rgba(153, 153, 153, 1)">13</li><li style="color: rgba(153, 153, 153, 1)">14</li><li style="color: rgba(153, 153, 153, 1)">15</li><li style="color: rgba(153, 153, 153, 1)">16</li><li style="color: rgba(153, 153, 153, 1)">17</li><li style="color: rgba(153, 153, 153, 1)">18</li><li style="color: rgba(153, 153, 153, 1)">19</li><li style="color: rgba(153, 153, 153, 1)">20</li><li style="color: rgba(153, 153, 153, 1)">21</li></ul></pre>
<h3>29、添加用户</h3>
<pre data-index="56" class="prettyprint"><code class="prism language-bash has-numbering" style="position: unset">db.createUser( {
user: "sa",
pwd: "sa",
roles: [ { role: "root", db: "admin" } ]
});
<div class="hljs-button {2}" data-title="复制"></div></code><ul class="pre-numbering" style=""><li style="color: rgba(153, 153, 153, 1)">1</li><li style="color: rgba(153, 153, 153, 1)">2</li><li style="color: rgba(153, 153, 153, 1)">3</li><li style="color: rgba(153, 153, 153, 1)">4</li><li style="color: rgba(153, 153, 153, 1)">5</li></ul></pre>
 </div> 
来源：https://www.cnblogs.com/duende99/p/17496695.html

頁: [1]

琼殿技术论坛's Archiver

MongoDB 语法大全