⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 sql语法手册.htm

📁 SQL语法手册.基本的。大家可以来看看呀！
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Kari<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Storgt 
            20<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Stavanger<O:P></O:P></SPAN></P></TD></TR></TBODY></TABLE>
      <P class=MsoNormal><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]>&nbsp;<![endif]><O:P></O:P></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]>&nbsp;<![endif]><O:P></O:P></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]>&nbsp;<![endif]><O:P></O:P></SPAN></P>
      <H1><SPAN lang=EN-US>Where</SPAN><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></H1>
      <P class=MsoNormal><B><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用途：</SPAN><SPAN 
      lang=EN-US><O:P></O:P></SPAN></B></P>
      <P class=MsoNormal 
      style="TEXT-INDENT: 10.5pt; mso-char-indent-count: 1.0; mso-char-indent-size: 10.5pt"><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">被用来规定一种选择查询的标准</SPAN><SPAN 
      lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P class=MsoNormal><B><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语法：</SPAN><SPAN 
      lang=EN-US><O:P></O:P></SPAN></B></P>
      <TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0 
      style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      width="100%">
        <TBODY>
        <TR>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 9.5pt">SELECT column FROM table WHERE column condition value<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">下面的操作符能被使用在</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">WHERE</SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">中：</SPAN><SPAN 
      lang=EN-US 
      style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US 
      style="COLOR: black; FONT-SIZE: 8.5pt">=,&lt;&gt;,&gt;,&lt;,&gt;=,&lt;=,BETWEEN,LIKE</SPAN><SPAN 
      lang=EN-US 
      style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">注意：</SPAN><SPAN 
      style="COLOR: black; FONT-SIZE: 8.5pt"> </SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">在某些</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">SQL</SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的版本中不等号</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">&lt; &gt;</SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">能被写作为</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">!=</SPAN><SPAN 
      lang=EN-US 
      style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P class=MsoNormal><B><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">解释：</SPAN></B><B><SPAN 
      lang=EN-US style="mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></B></P>
      <P class=MsoNormal><SPAN lang=EN-US><SPAN style="mso-spacerun: yes">&nbsp; 
      </SPAN>SELECT</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语句返回</SPAN><SPAN 
      lang=EN-US>WHERE</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">子句中条件为</SPAN><SPAN 
      lang=EN-US>true</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的数据</SPAN><SPAN 
      lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P class=MsoNormal><B><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">例：</SPAN></B><B><SPAN 
      lang=EN-US style="mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></B></P>
      <P><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">从</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">”<B> 
      </B>Persons”</SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">表中选出生活在</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">” Sandnes” </SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的人</SPAN><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><O:P></O:P></SPAN></P>
      <TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0 
      style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      width="100%">
        <TBODY>
        <TR>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 9.5pt">SELECT * FROM Persons WHERE City='Sandnes'<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
      <P><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><SPAN 
      style="mso-spacerun: yes">&nbsp;</SPAN>"Persons" </SPAN><SPAN 
      style="COLOR: black; FONT-FAMILY: 宋体; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">表中的数据有</SPAN><B><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">:</SPAN></B><SPAN 
      lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><O:P></O:P></SPAN></P>
      <TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0 
      style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      width="100%">
        <TBODY>
        <TR>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">LastName</SPAN></B><B><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">FirstName</SPAN></B><B><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Address</SPAN></B><B><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">City</SPAN></B><B><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Year</SPAN></B><B><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD></TR>
        <TR>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Hansen</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Ola</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Timoteivn 
            10</SPAN><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Sandnes</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">1951</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD></TR>
        <TR>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Svendson</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Tove</SPAN><SPAN 
            lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Borgvn 
            23</SPAN><SPAN lang=EN-US 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -