MySQL与MongoDB的操作对比

lzq467826892

                &nbsp;<font class="Apple-style-span" size="3"> &nbsp; MySQL与MongoDB都是开源的常用数据库，但是MySQL是传统的关系型数据库，MongoDB则是非关系型数据库，也叫文档型数据库，是一种NoSQL的数据库。它们各有各的优点，关键是看用在什么地方。</font><div><font class="Apple-style-span" size="3">&nbsp; &nbsp; 以我们公司项目为例，在早期的项目中，都在使用关系型数据库，用过SQLServer,Oracle,DB2,后来全部转向Mysql,原因很简单：Mysql在性能不错的情况下，有着开源优势。Mysql的事务性与高性能是我们主要考虑的。后来，由于项目要用到用户系统，即会有大量的用户数据进行交互－－海量存储，Mysql的读写速度会有一点瓶颈，于是我们就想到了最近发展很强势的Nosql。在Nosql早期的memcache的发展下，又出现了很多非关系型数据库，比如redis,mongodb。经过一段时间的测试，redis与mongodb的读写速度确实比Mysql有着很明显的优势。mongodb的写入速度大约2.5W/次每秒。</font></div><div><font class="Apple-style-span" size="3">&nbsp; &nbsp; mongodb以BSON结构（二进制）进行存储，对海量数据存储有着很明显的优势。下面是Mongodb与Mysql的操作命令的对比</font>。</div><div><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="641" style="width:481.0pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook:
1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt">
<tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  mso-border-alt:solid windowtext .5pt;background:yellow;padding:0cm 5.4pt 0cm 5.4pt;
  height:13.5pt">
  <p class="MsoNormal" align="center" style="margin-bottom:3.0pt;text-align:center;
  line-height:normal;mso-pagination:widow-orphan"><span style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">作用<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
  yellow;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="center" style="text-align:center;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">MySQL<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
  yellow;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="center" style="text-align:center;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">MongoDB<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:1;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
  #D8D8D8;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  background:#D8D8D8;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  background:#D8D8D8;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:2;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">服务器守护进程<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mysqld<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongod<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:3;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">客户端工具<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mysql<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongo<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:4;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">逻辑备份工具<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mysqldump<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongodump<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:5;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">逻辑还原工具<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mysql<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongorestore<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:6;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">数据导出工具<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mysqldump<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongoexport<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:7;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">数据导入工具<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">source<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">mongoimport<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:8;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:9;height:40.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:40.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">新建用户并授权<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">grant
  all on *.* <br>
  to username@'localhost'<br>
  <span style="mso-spacerun:yes">&nbsp;</span>identified by 'passwd';<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.addUser("user","psw")<br>
  db.auth("user","psw")<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:10;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">显示库列表<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">show
  databases;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">show
  dbs<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:11;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">进去库<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">use
  dbname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">use
  dbname<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:12;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">显示表列表<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">show
  tables;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">show
  collections<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:13;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">查询主从状态<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">show
  slave status;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">rs.status<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:14;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">创建库<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">create
  database name;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">无需单独创建，直接<span lang="EN-US">use</span>进去<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:15;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">创建表<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">create
  table tname(id int);<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">无需单独创建，直接插入数据<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:16;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">删除表<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">drop
  table tname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.drop()<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:17;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">删除库<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">drop
  database dbname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">首先进去该库，<span lang="EN-US">db.dropDatabase()<o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:18;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:19;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">插入记录<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">insert
  into tname(id) value(2);<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.insert({id:2})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:20;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">删除记录<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">delete
  from tname where id=2;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.remove({id:2})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:21;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">修改<span lang="EN-US">/</span>更新记录<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">update
  tname set id=3 <br>
  where id=2;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.update({id:2},<br>
  {$set:{id:3}},false,true)<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:22;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:23;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">查询所有记录<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find()<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:24;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">查询所有列<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  id from tname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({},{id:1})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:25;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where id=2;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id:2})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:26;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where id &lt; 2;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id:{$lt:2}})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:27;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where id &gt;=2;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id:{$gte:2}})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:28;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where id=2 <br>
  and name='steve';<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id:2,<br>
  name:'steve'})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:29;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where id=2<br>
  or name='steve';<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find($or:[{id:2},<br>
  {name:'steve'}])<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:30;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">条件查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname limit 1;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.findOne()<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:31;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:32;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">模糊查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where name<br>
  like "%ste%";<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({name:/ste/})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:33;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">模糊查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  * from tname where name<br>
  like "ste%";<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({name:/^ste/})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:34;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:35;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">获取表记录数<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  count(id) from tname;<o:p></o:p></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.count()<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:36;height:27.0pt">
  <td width="111" style="width:83.0pt;border:solid windowtext 1.0pt;border-top:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
  height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">获取有条件<span lang="EN-US"><br>
  </span>的记录数<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  count(id) from tname<br>
  where id=2;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id:2}).count()<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:37;height:27.0pt">
  <td width="111" style="width:83.0pt;border:solid windowtext 1.0pt;border-top:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
  height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">查询时去掉<span lang="EN-US"><br>
  </span>重复值<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  distinct(last_name)<br>
  from tname;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.distinct('last_name')<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:38;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:39;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">正排序查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  *from tname order by id;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find().sort({id:1})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:40;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">逆排序查询<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">select
  *from tname <br>
  order by id desc;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find().sort({id:-1})<o:p></o:p></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:41;height:13.5pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" nowrap="" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="260" nowrap="" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">　<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
</tr>
<tr style="mso-yfti-irow:42;mso-yfti-lastrow:yes;height:27.0pt">
  <td width="111" nowrap="" style="width:83.0pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
  solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
  0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span style="font-size:11.0pt;font-family:宋体;
  mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">取存储路径<span lang="EN-US"><o:p></o:p></span></span></p>
  </td>
  <td width="271" style="width:203.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">explain
  select * from tname<br>
  where id=3;<o:p></o:p></span></p>
  </td>
  <td width="260" style="width:195.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt">
  <p class="MsoNormal" align="left" style="text-align:left;line-height:normal;
  mso-pagination:widow-orphan"><span lang="EN-US" style="font-size:11.0pt;
  font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:0pt">db.tname.find({id=3}).explain()</span></p></td></tr></tbody></table><br></div><div><font class="Apple-style-span" size="4" color="#ff0102">特别要注意的是：mongodb插入多个字段语法</font></div><div><font class="Apple-style-span" size="4" color="#ff0102">&gt; db.user.insert({id:1,name:'steve',sex:'male'}) &nbsp;正确</font></div><div><font class="Apple-style-span" size="4" color="#ff0102">&gt; db.user.insert({id:2},{name:'bear'},{sex:'female'}) &nbsp;错误</font></div>
               
               
               

飞鸿无痕

学习了，很好的学习文档，对比起来学习，真不错！