sql-92.bnf.html

sql 92的 bnf范式

<a href="#xref-SQL%20language%20character"> &lt;SQL language character&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#simple%20Latin%20letter">&lt;simple Latin letter&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#digit">&lt;digit&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#SQL%20special%20character">&lt;SQL special character&gt;</a>
</p><p><a name="simple Latin letter"> &nbsp; </a>
<a href="#xref-simple%20Latin%20letter"> &lt;simple Latin letter&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#simple%20Latin%20upper%20case%20letter">&lt;simple Latin upper case letter&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#simple%20Latin%20lower%20case%20letter">&lt;simple Latin lower case letter&gt;</a>
</p><p><a name="simple Latin upper case letter"> &nbsp; </a>
<a href="#xref-simple%20Latin%20upper%20case%20letter"> &lt;simple Latin upper case letter&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-A"> A </a>  |  <a href="#xref-B"> B </a>  |  <a href="#xref-C"> C </a>  |  <a href="#xref-D"> D </a>  |  <a href="#xref-E"> E </a>  |  <a href="#xref-F"> F </a>  |  <a href="#xref-G"> G </a>  |  <a href="#xref-H"> H </a>  |  <a href="#xref-I"> I </a>  |  <a href="#xref-J"> J </a>  |  <a href="#xref-K"> K </a>  |  <a href="#xref-L"> L </a>  |  <a href="#xref-M"> M </a>  |  <a href="#xref-N"> N </a>  |  <a href="#xref-O"> O </a>  |  <a href="#xref-P"> P </a>  |  <a href="#xref-Q"> Q </a>  |  <a href="#xref-R"> R </a>  |  <a href="#xref-S"> S </a>  |  <a href="#xref-T"> T </a>  |  <a href="#xref-U"> U </a>  |  <a href="#xref-V"> V </a>  |  <a href="#xref-W"> W </a>  |  <a href="#xref-X"> X </a>  |  <a href="#xref-Y"> Y </a>  |  <a href="#xref-Z"> Z </a>
</p><p><a name="simple Latin lower case letter"> &nbsp; </a>
<a href="#xref-simple%20Latin%20lower%20case%20letter"> &lt;simple Latin lower case letter&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-a"> a </a>  |  <a href="#xref-b"> b </a>  |  <a href="#xref-c"> c </a>  |  <a href="#xref-d"> d </a>  |  <a href="#xref-e"> e </a>  |  <a href="#xref-f"> f </a>  |  <a href="#xref-g"> g </a>  |  <a href="#xref-h"> h </a>  |  <a href="#xref-i"> i </a>  |  <a href="#xref-j"> j </a>  |  <a href="#xref-k"> k </a>  |  <a href="#xref-l"> l </a>  |  <a href="#xref-m"> m </a>  |  <a href="#xref-n"> n </a>  |  <a href="#xref-o"> o </a>  |  <a href="#xref-p"> p </a>  |  <a href="#xref-q"> q </a>  |  <a href="#xref-r"> r </a>  |  <a href="#xref-s"> s </a>  |  <a href="#xref-t"> t </a>  |  <a href="#xref-u"> u </a>  |  <a href="#xref-v"> v </a>  |  <a href="#xref-w"> w </a>  |  <a href="#xref-x"> x </a>  |  <a href="#xref-y"> y </a>  |  <a href="#xref-z"> z </a>
</p><p><a name="digit"> &nbsp; </a>
<a href="#xref-digit"> &lt;digit&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-0"> 0 </a>  |  <a href="#xref-1"> 1 </a>  |  <a href="#xref-2"> 2 </a>  |  <a href="#xref-3"> 3 </a>  |  <a href="#xref-4"> 4 </a>  |  <a href="#xref-5"> 5 </a>  |  <a href="#xref-6"> 6 </a>  |  <a href="#xref-7"> 7 </a>  |  <a href="#xref-8"> 8 </a>  |  <a href="#xref-9"> 9 </a>
</p><p><a name="SQL special character"> &nbsp; </a>
<a href="#xref-SQL%20special%20character"> &lt;SQL special character&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#space">&lt;space&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#double%20quote">&lt;double quote&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#percent">&lt;percent&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#ampersand">&lt;ampersand&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#left%20paren">&lt;left paren&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#right%20paren">&lt;right paren&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#asterisk">&lt;asterisk&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#plus%20sign">&lt;plus sign&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#comma">&lt;comma&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#minus%20sign">&lt;minus sign&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#period">&lt;period&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#solidus">&lt;solidus&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#colon">&lt;colon&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#semicolon">&lt;semicolon&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#less%20than%20operator">&lt;less than operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#greater%20than%20operator">&lt;greater than operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#equals%20operator">&lt;equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#question%20mark">&lt;question mark&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#underscore">&lt;underscore&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#vertical%20bar">&lt;vertical bar&gt;</a>
</p><p><a name="space"> &nbsp; </a>
<a href="#xref-space"> &lt;space&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! space character in character set in use </font>

</p><p><a name="double quote"> &nbsp; </a>
<a href="#xref-double%20quote"> &lt;double quote&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; "

</p><p><a name="percent"> &nbsp; </a>
<a href="#xref-percent"> &lt;percent&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; %

</p><p><a name="ampersand"> &nbsp; </a>
<a href="#xref-ampersand"> &lt;ampersand&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &amp;

</p><p><a name="quote"> &nbsp; </a>
<a href="#xref-quote"> &lt;quote&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; '

</p><p><a name="left paren"> &nbsp; </a>
<a href="#xref-left%20paren"> &lt;left paren&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; (

</p><p><a name="right paren"> &nbsp; </a>
<a href="#xref-right%20paren"> &lt;right paren&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; )

</p><p><a name="asterisk"> &nbsp; </a>
<a href="#xref-asterisk"> &lt;asterisk&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; *

</p><p><a name="plus sign"> &nbsp; </a>
<a href="#xref-plus%20sign"> &lt;plus sign&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; +

</p><p><a name="comma"> &nbsp; </a>
<a href="#xref-comma"> &lt;comma&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ,

</p><p><a name="minus sign"> &nbsp; </a>
<a href="#xref-minus%20sign"> &lt;minus sign&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; -

</p><p><a name="period"> &nbsp; </a>
<a href="#xref-period"> &lt;period&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; .

</p><p><a name="solidus"> &nbsp; </a>
<a href="#xref-solidus"> &lt;solidus&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; /

</p><p><a name="colon"> &nbsp; </a>
<a href="#xref-colon"> &lt;colon&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; :

</p><p><a name="semicolon"> &nbsp; </a>
<a href="#xref-semicolon"> &lt;semicolon&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ;

</p><p><a name="less than operator"> &nbsp; </a>
<a href="#xref-less%20than%20operator"> &lt;less than operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &lt;

</p><p><a name="equals operator"> &nbsp; </a>
<a href="#xref-equals%20operator"> &lt;equals operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; =

</p><p><a name="greater than operator"> &nbsp; </a>
<a href="#xref-greater%20than%20operator"> &lt;greater than operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &gt;

</p><p><a name="question mark"> &nbsp; </a>
<a href="#xref-question%20mark"> &lt;question mark&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ?

</p><p><a name="underscore"> &nbsp; </a>
<a href="#xref-underscore"> &lt;underscore&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-_"> _ </a>

</p><p><a name="vertical bar"> &nbsp; </a>
<a href="#xref-vertical%20bar"> &lt;vertical bar&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red">/* Nothing */</font>  |

</p><p><a name="SQL embedded language character"> &nbsp; </a>
<a href="#xref-SQL%20embedded%20language%20character"> &lt;SQL embedded language character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#left%20bracket">&lt;left bracket&gt;</a>  |  <a href="#right%20bracket">&lt;right bracket&gt;</a>

</p><p><a name="left bracket"> &nbsp; </a>
<a href="#xref-left%20bracket"> &lt;left bracket&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; [

</p><p><a name="right bracket"> &nbsp; </a>
<a href="#xref-right%20bracket"> &lt;right bracket&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ]

</p><p><a name="token"> &nbsp; </a>
<a href="#xref-token"> &lt;token&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#nondelimiter%20token">&lt;nondelimiter token&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#delimiter%20token">&lt;delimiter token&gt;</a>
</p><p><a name="nondelimiter token"> &nbsp; </a>
<a href="#xref-nondelimiter%20token"> &lt;nondelimiter token&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#regular%20identifier">&lt;regular identifier&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#key%20word">&lt;key word&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#unsigned%20numeric%20literal">&lt;unsigned numeric literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#national%20character%20string%20literal">&lt;national character string literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#bit%20string%20literal">&lt;bit string literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#hex%20string%20literal">&lt;hex string literal&gt;</a>
</p><p><a name="regular identifier"> &nbsp; </a>
<a href="#xref-regular%20identifier"> &lt;regular identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier%20body">&lt;identifier body&gt;</a>

</p><p><a name="identifier body"> &nbsp; </a>
<a href="#xref-identifier%20body"> &lt;identifier body&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier%20start">&lt;identifier start&gt;</a>  [  {  <a href="#underscore">&lt;underscore&gt;</a>  |  <a href="#identifier%20part">&lt;identifier part&gt;</a>  }  ...  ]