lang_expr.html
来自「sqlite 3.3.8 支持加密的版本」· HTML 代码 · 共 267 行 · 第 1/2 页
HTML
267 行
<html dir="LTR" xmlns="http://www.w3.org/1999/xhtml" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:MSHelp="http://msdn.microsoft.com/mshelp" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:ndoc="urn:ndoc-preprocess">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252" />
<title>expression</title>
<link rel="stylesheet" type="text/css" href="ndoc.css"> </link>
<link rel="stylesheet" type="text/css" href="user.css"> </link>
<script type="text/javascript" src="ndoc.js"> </script>
</head>
<body style="display: none;">
<input type="hidden" id="userDataCache" class="userDataStyle" />
<input type="hidden" id="hiddenScrollOffset" />
<img id="dropDownImage" style="display:none; height:0; width:0;" src="drpdown.gif" />
<img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="drpdown_orange.gif" />
<img id="collapseImage" style="display:none; height:0; width:0;" src="collapse.gif" />
<img id="expandImage" style="display:none; height:0; width:0;" src="exp.gif" />
<img id="collapseAllImage" style="display:none; height:0; width:0;" src="collall.gif" />
<img id="expandAllImage" style="display:none; height:0; width:0;" src="expall.gif" />
<img id="copyImage" style="display:none; height:0; width:0;" src="copycode.gif" />
<img id="copyHoverImage" style="display:none; height:0; width:0;" src="copycodeHighlight.gif" />
<div id="header">
<table width="100%" id="topTable">
<tr id="headerTableRow1">
<td align="left">
<span id="runningHeaderText">expression</span> </td>
</tr>
<tr id="headerTableRow2">
<td align="left">
<span id="nsrTitle">SQLite Language Reference Documentation</span>
</td>
</tr>
<tr id="headerTableRow3" style="display:none">
<td>
<a id="seeAlsoSectionLink" href="#seeAlsoToggle" onclick="OpenSection(seeAlsoToggle)">See Also</a>
<a id="exampleSectionLink" href="#codeExampleToggle" onclick="OpenSection(codeExampleToggle)">Example</a>
</td>
</tr>
</table>
<table width="100%" id="bottomTable" cellspacing="0" cellpadding="0" style="display:none">
<tr>
<td>
<span onclick="ExpandCollapseAll(toggleAllImage)" style="cursor:default;" onkeypress="ExpandCollapseAll_CheckKey(toggleAllImage)" tabindex="0">
<img ID="toggleAllImage" class="toggleAll" src="collall.gif" />
<label id="collapseAllLabel" for="toggleAllImage" style="display: none;">
Collapse All
</label>
<label id="expandAllLabel" for="toggleAllImage" style="display: none;">
Expand All
</label>
</span>
</td>
</tr>
</table>
</div>
<div id="mainSection">
<div id="mainBody">
<h1 class="heading">
SQL As Understood By SQLite</h1>
<h4>
expression</h4>
<p>
<table cellpadding="10">
<tr>
<td align="right" width="1%" nowrap>
<i><font color="#ff3434">expr</font></i> ::=</td>
<td>
<b><font color="#2c2cf0"></font></b><i><font color="#ff3434">expr</font></i><b><font
color="#2c2cf0"> </font></b><i><font color="#ff3434">binary-op</font></i><b><font
color="#2c2cf0"> </font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font>
</b>[<b><font color="#2c2cf0">NOT</font></b>]<b><font color="#2c2cf0"> </font></b>
<i><font color="#ff3434">like-op</font></i><b><font color="#2c2cf0"> </font></b>
<i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font></b>[<b><font
color="#2c2cf0">ESCAPE </font></b><i><font color="#ff3434">expr</font></i><b><font
color="#2c2cf0"></font></b>]<b><font color="#2c2cf0"> </font></b><big>|</big><b><font
color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">unary-op</font></i><b><font color="#2c2cf0"> </font>
</b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font></b>
<big>|</big><b><font color="#2c2cf0"><br />
<big>(</big> </font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0">
<big>)</big> </font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">column-name</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">table-name</font></i><b><font color="#2c2cf0">
<big>.</big> </font></b><i><font color="#ff3434">column-name</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">database-name</font></i><b><font color="#2c2cf0">
<big>.</big> </font></b><i><font color="#ff3434">table-name</font></i><b><font color="#2c2cf0">
<big>.</big> </font></b><i><font color="#ff3434">column-name</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">literal-value</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">parameter</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">function-name</font></i><b><font color="#2c2cf0">
<big>(</big> </font></b><i><font color="#ff3434">expr-list</font></i><b><font color="#2c2cf0">
</font></b><big>|</big><b><font color="#2c2cf0"> <big>*</big> <big>)</big> </font>
</b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> ISNULL
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> NOTNULL
</font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font>
</b>[<b><font color="#2c2cf0">NOT</font></b>]<b><font color="#2c2cf0"> BETWEEN </font>
</b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> AND </font></b>
<i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font></b><big>
|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font>
</b>[<b><font color="#2c2cf0">NOT</font></b>]<b><font color="#2c2cf0"> IN <big>(</big>
</font></b><i><font color="#ff3434">value-list</font></i><b><font color="#2c2cf0">
<big>)</big> </font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font>
</b>[<b><font color="#2c2cf0">NOT</font></b>]<b><font color="#2c2cf0"> IN <big>(</big>
</font></b><i><font color="#ff3434">select-statement</font></i><b><font color="#2c2cf0">
<big>)</big> </font></b><big>|</big><b><font color="#2c2cf0"><br />
</font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"> </font>
</b>[<b><font color="#2c2cf0">NOT</font></b>]<b><font color="#2c2cf0"> IN </font></b>
[<b><font color="#2c2cf0"></font></b><i><font color="#ff3434">database-name</font></i><b><font
color="#2c2cf0"> <big>.</big></font></b>]<b><font color="#2c2cf0"> </font></b>
<i><font color="#ff3434">table-name</font></i><b><font color="#2c2cf0"> </font></b>
<big>|</big><b><font color="#2c2cf0"><br />
</font></b>[<b><font color="#2c2cf0">EXISTS</font></b>]<b><font color="#2c2cf0"> <big>
(</big> </font></b><i><font color="#ff3434">select-statement</font></i><b><font color="#2c2cf0">
<big>)</big> </font></b><big>|</big><b><font color="#2c2cf0"><br />
CASE </font></b>[<b><font color="#2c2cf0"></font></b><i><font color="#ff3434">expr</font></i><b><font
color="#2c2cf0"></font></b>]<b><font color="#2c2cf0"> </font></b>(<b><font color="#2c2cf0">
WHEN </font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0">
THEN </font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0">
</font></b>)+<b><font color="#2c2cf0"> </font></b>[<b><font color="#2c2cf0">ELSE </font>
</b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0"></font></b>]<b><font
color="#2c2cf0"> END </font></b><big>|</big><b><font color="#2c2cf0"><br />
CAST <big>(</big> </font></b><i><font color="#ff3434">expr</font></i><b><font color="#2c2cf0">
AS </font></b><i><font color="#ff3434">type</font></i><b><font color="#2c2cf0"> <big>
)</big></font></b></td>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?