sql-2003-2.bnf.html

sql 2003的 bnf范式

<li> SET CATALOG <a href='#set catalog statement'>&lt;set catalog statement&gt;</a>
<li> SET CONNECTION <a href='#set connection statement'>&lt;set connection statement&gt;</a>
<li> SET CONSTRAINTS <a href='#set constraints mode statement'>&lt;set constraints mode statement&gt;</a>
<li> SET NAMES <a href='#set names statement'>&lt;set names statement&gt;</a>
<li> SET SCHEMA <a href='#set schema statement'>&lt;set schema statement&gt;</a>
<li> SET SESSION AUTHORIZATION <a href='#set session user identifier statement'>&lt;set session user identifier statement&gt;</a>
<li> SET TIME ZONE <a href='#set local time zone statement'>&lt;set local time zone statement&gt;</a>
<li> SET TRANSACTION <a href='#set transaction statement'>&lt;set transaction statement&gt;</a>
<li> SQL Client MODULE <a href='#SQL-client module definition'>&lt;SQL-client module definition&gt;</a>
<li> UPDATE <a href='#update statement: positioned'>&lt;update statement: positioned&gt;</a> <a href='#update statement: searched'>&lt;update statement: searched&gt;</a> <a href='#dynamic update statement: positioned'>&lt;dynamic update statement: positioned&gt;</a>
<li> Value expression <a href='#value expression'>&lt;value expression&gt;</a>
<li> WHERE clause <a href='#where clause'>&lt;where clause&gt;</a>
</bl>

<p><a href='#top'>Top</a></p>

<hr>
<h2> 5 Lexical Elements
</h2>

<p>
Basic definitions of characters used, tokens, symbols, etc.
Most of this section would normally be handled within the lexical
analyzer rather than in the grammar proper.
Further, the original document does not quote the various single
characters, which makes it hard to process automatically.
</p>

<h3> 5.1 <a href='#SQL terminal character'>&lt;SQL terminal character&gt;</a> (p151)
</h3>

<p><a name="SQL terminal character"> &nbsp; </a>
<a href="#xref-SQL terminal character"> &lt;SQL terminal character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#SQL language character'>&lt;SQL language character&gt;</a>

<p><a name="SQL language character"> &nbsp; </a>
<a href="#xref-SQL language character"> &lt;SQL language character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#simple Latin letter'>&lt;simple Latin letter&gt;</a>  |  <a href='#digit'>&lt;digit&gt;</a>  |  <a href='#SQL special character'>&lt;SQL special character&gt;</a>

<p><a name="simple Latin letter"> &nbsp; </a>
<a href="#xref-simple Latin letter"> &lt;simple Latin letter&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#simple Latin upper case letter'>&lt;simple Latin upper case letter&gt;</a>  |  <a href='#simple Latin lower case letter'>&lt;simple Latin lower case letter&gt;</a>

<p><a name="simple Latin upper case letter"> &nbsp; </a>
<a href="#xref-simple Latin upper case letter"> &lt;simple Latin upper case letter&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&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><a name="simple Latin lower case letter"> &nbsp; </a>
<a href="#xref-simple Latin lower case letter"> &lt;simple Latin lower case letter&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&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><a name="digit"> &nbsp; </a>
<a href="#xref-digit"> &lt;digit&gt; </a>&nbsp;&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><a name="SQL special character"> &nbsp; </a>
<a href="#xref-SQL special character"> &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 quote'>&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 paren'>&lt;left paren&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#right paren'>&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 sign'>&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 sign'>&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 than operator'>&lt;less than operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#equals operator'>&lt;equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#greater than operator'>&lt;greater than operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#question mark'>&lt;question mark&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#left bracket'>&lt;left bracket&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#right bracket'>&lt;right bracket&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#circumflex'>&lt;circumflex&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 bar'>&lt;vertical bar&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#left brace'>&lt;left brace&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#right brace'>&lt;right brace&gt;</a>
<p><a name="space"> &nbsp; </a>
<a href="#xref-space"> &lt;space&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax Rules </font>

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

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

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

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

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

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

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

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

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

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