sql语法手册.htm

讲解了sql的基本用法

        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="FONT-SIZE: 9.5pt; COLOR: black">SELECT * FROM Persons<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">返回结果</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">:<O:P></O:P></SPAN></P>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US 
      style="FONT-SIZE: 8.5pt; COLOR: black">&nbsp;<O:P></O:P></SPAN></P>
      <TABLE style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      cellSpacing=0 cellPadding=0 width="100%" bgColor=#eeeedd border=1>
        <TBODY>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">LastName<O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">FirstName<O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Address<O:P></O:P></SPAN></B></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">City<O:P></O:P></SPAN></B></P></TD></TR>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Hansen<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Ola<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Timoteivn 
            10<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Sandnes<O:P></O:P></SPAN></P></TD></TR>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Svendson<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Tove<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Borgvn 
            23<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Sandnes<O:P></O:P></SPAN></P></TD></TR>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Pettersen<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Kari<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Storgt 
            20<O:P></O:P></SPAN></P></TD>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">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">&nbsp;<O:P></O:P></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW">&nbsp;<O:P></O:P></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US 
      style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW">&nbsp;<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-hansi-font-family: 'Times New Roman'; mso-ascii-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-hansi-font-family: 'Times New Roman'; mso-ascii-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-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">语法：</SPAN><SPAN 
      lang=EN-US><O:P></O:P></SPAN></B></P>
      <TABLE style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      cellSpacing=0 cellPadding=0 width="100%" bgColor=#eeeedd border=1>
        <TBODY>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="FONT-SIZE: 9.5pt; COLOR: black">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="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">下面的操作符能被使用在</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">WHERE</SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">中：</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 8.5pt; COLOR: black; 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="FONT-SIZE: 8.5pt; COLOR: black">=,&lt;&gt;,&gt;,&lt;,&gt;=,&lt;=,BETWEEN,LIKE</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 8.5pt; COLOR: black; mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">注意：</SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black"> </SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">在某些</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">SQL</SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">的版本中不等号</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">&lt; &gt;</SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">能被写作为</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">!=</SPAN><SPAN 
      lang=EN-US 
      style="FONT-SIZE: 8.5pt; COLOR: black; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
      <P class=MsoNormal><B><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-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-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">语句返回</SPAN><SPAN 
      lang=EN-US>WHERE</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">子句中条件为</SPAN><SPAN 
      lang=EN-US>true</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-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-hansi-font-family: 'Times New Roman'; mso-ascii-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="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">从</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">”<B> 
      </B>Persons”</SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">表中选出生活在</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">” Sandnes” </SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">的人</SPAN><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black"><O:P></O:P></SPAN></P>
      <TABLE style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      cellSpacing=0 cellPadding=0 width="100%" bgColor=#eeeedd border=1>
        <TBODY>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="FONT-SIZE: 9.5pt; COLOR: black">SELECT * FROM Persons WHERE City='Sandnes'<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
      <P><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black"><SPAN 
      style="mso-spacerun: yes">&nbsp;</SPAN>"Persons" </SPAN><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">表中的数据有</SPAN><B><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">:</SPAN></B><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black"><O:P></O:P></SPAN></P>
      <TABLE style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm" 
      cellSpacing=0 cellPadding=0 width="100%" bgColor=#eeeedd border=1>
        <TBODY>
        <TR>
          <TD 
          style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">LastName</SPAN></B><B><SPAN 
            lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">FirstName</SPAN></B><B><SPAN 
            lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
            <P class=MsoNormal><B><SPAN lang=EN-US 
            style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Address</SPAN></B><B><SPAN