1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
|
<!DOCTYPE html>
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Syntax: update-stmt</title>
<!-- path=../ -->
</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
<div class="tagline desktoponly">
Small. Fast. Reliable.<br>Choose any three.
</div>
<div class="menu mainmenu">
<ul>
<li><a href="../index.html">Home</a>
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
<li class='wideonly'><a href='../about.html'>About</a>
<li class='desktoponly'><a href="../docs.html">Documentation</a>
<li class='desktoponly'><a href="../download.html">Download</a>
<li class='wideonly'><a href='../copyright.html'>License</a>
<li class='desktoponly'><a href="../support.html">Support</a>
<li class='desktoponly'><a href="../prosupport.html">Purchase</a>
<li class='search' id='search_menubutton'>
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
</ul>
</div>
<div class="menu submenu" id="submenu">
<ul>
<li><a href='../about.html'>About</a>
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="../search">
<select name="s" id="searchtype">
<option value="d">Search Documentation</option>
<option value="c">Search Changelog</option>
</select>
<input type="text" name="q" id="searchbox" value="">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
var w = document.getElementById(nm);
if( w.style.display=="block" ){
w.style.display = "none";
}else{
w.style.display = "block";
}
}
function toggle_search() {
var w = document.getElementById("searchmenu");
if( w.style.display=="block" ){
w.style.display = "none";
} else {
w.style.display = "block";
setTimeout(function(){
document.getElementById("searchbox").focus()
}, 30);
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){
x.style.display = 'none';
b.innerHTML='show';
}else{
x.style.display = '';
b.innerHTML='hide';
}
return false;
}
var antiRobot = 0;
function antiRobotGo(){
if( antiRobot!=3 ) return;
antiRobot = 7;
var j = document.getElementById("mtimelink");
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
}
function antiRobotDefense(){
document.body.onmousedown=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousedown=null;
}
document.body.onmousemove=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousemove=null;
}
setTimeout(function(){
antiRobot |= 1;
antiRobotGo();
}, 100)
antiRobotGo();
}
antiRobotDefense();
</script>
<h1 align='center'>update-stmt</h1>
<div class='imgcontainer'>
<div style="max-width:623px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 623.266 721.926">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
<path d="M9,17L39,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,32L91,32A15 15 0 0 0 106 17A15 15 0 0 0 91 2L60,2A15 15 0 0 0 45 17A15 15 0 0 0 60 32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="75" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WITH</text>
<path d="M166,62L252,62A15 15 0 0 0 267 47L267,47A15 15 0 0 0 252 32L166,32A15 15 0 0 0 151 47L151,47A15 15 0 0 0 166 62Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="209" y="47" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">RECURSIVE</text>
<polygon points="209,17 197,21 197,12" style="fill:rgb(0,0,0)"/>
<path d="M106,17L203,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="357,17 345,21 345,12" style="fill:rgb(0,0,0)"/>
<path d="M209,17L351,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M357,32L583,32L583,2L357,2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="470" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">common-table-expression</text>
<polygon points="151,47 139,51 139,43" style="fill:rgb(0,0,0)"/>
<path d="M106,17 L 113,17 Q 121,17 121,32 L 121,32 Q 121,47 133,47 L 145,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="290,47 278,51 278,43" style="fill:rgb(0,0,0)"/>
<path d="M267,47L284,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M290,47 L 297,47 Q 305,47 305,32 L 305,32 Q 305,17 320,17 L 330,17 L 345,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M470,70A15 15 0 0 0 485 55L485,55A15 15 0 0 0 470 39A15 15 0 0 0 455 55L455,55A15 15 0 0 0 470 70Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="470" y="55" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="485,55 497,50 497,59" style="fill:rgb(0,0,0)"/>
<path d="M583,17 L 591,17 Q 598,17 598,32 L 598,40 Q 598,55 583,55 L 506,55 L 491,55" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M455,55 L 349,55 Q 334,55 334,40 L 334,32 Q 334,17 340,17 L 345,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="294,83 306,79 306,88" style="fill:rgb(0,0,0)"/>
<path d="M583,17 L 591,17 Q 598,17 598,32 L 598,68 Q 598,83 583,83 L 315,83 L 300,83" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="24,53 20,41 28,41" style="fill:rgb(0,0,0)"/>
<path d="M9,17 L 16,17 Q 24,17 24,32 L 24,32 L 24,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,136L114,136A15 15 0 0 0 129 121A15 15 0 0 0 114 106L60,106A15 15 0 0 0 45 121A15 15 0 0 0 60 136Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="87" y="121" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UPDATE</text>
<polygon points="45,121 33,125 33,116" style="fill:rgb(0,0,0)"/>
<path d="M24,53 L 24,106 Q 24,121 31,121 L 39,121" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M294,83 L 39,83 Q 24,83 24,91 L 24,98" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,299 159,303 159,295" style="fill:rgb(0,0,0)"/>
<path d="M129,121 L 137,121 Q 144,121 144,136 L 144,284 Q 144,299 155,299 L 165,299" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M186,314L193,314A15 15 0 0 0 208 299A15 15 0 0 0 193 284L186,284A15 15 0 0 0 171 299A15 15 0 0 0 186 314Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="189" y="299" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="225,299 214,303 214,295" style="fill:rgb(0,0,0)"/>
<path d="M208,299L219,299" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,314L318,314A15 15 0 0 0 333 299A15 15 0 0 0 318 284L240,284A15 15 0 0 0 225 299A15 15 0 0 0 240 314Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="279" y="299" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ROLLBACK</text>
<polygon points="350,299 339,303 339,295" style="fill:rgb(0,0,0)"/>
<path d="M333,299L344,299" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="392,121 380,125 380,116" style="fill:rgb(0,0,0)"/>
<path d="M350,299 L 358,299 Q 365,299 365,284 L 365,136 Q 365,121 376,121 L 386,121" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M392,136L576,136L576,106L392,106Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="484" y="121" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">qualified-table-name</text>
<path d="M186,276L193,276A15 15 0 0 0 208 261A15 15 0 0 0 193 246L186,246A15 15 0 0 0 171 261A15 15 0 0 0 186 276Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="189" y="261" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="225,261 214,266 214,257" style="fill:rgb(0,0,0)"/>
<path d="M208,261L219,261" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,276L304,276A15 15 0 0 0 319 261A15 15 0 0 0 304 246L240,246A15 15 0 0 0 225 261A15 15 0 0 0 240 276Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="272" y="261" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">REPLACE</text>
<polygon points="350,261 339,266 339,257" style="fill:rgb(0,0,0)"/>
<path d="M319,261L344,261" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M350,261 L 358,261 Q 365,261 365,254 L 365,246" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,261 159,266 159,257" style="fill:rgb(0,0,0)"/>
<path d="M144,246 L 144,254 Q 144,261 155,261 L 165,261" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M186,239L193,239A15 15 0 0 0 208 224A15 15 0 0 0 193 208L186,208A15 15 0 0 0 171 224A15 15 0 0 0 186 239Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="189" y="224" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="225,224 214,228 214,219" style="fill:rgb(0,0,0)"/>
<path d="M208,224L219,224" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,239L292,239A15 15 0 0 0 307 224A15 15 0 0 0 292 208L240,208A15 15 0 0 0 225 224A15 15 0 0 0 240 239Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="266" y="224" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IGNORE</text>
<polygon points="350,224 339,228 339,219" style="fill:rgb(0,0,0)"/>
<path d="M307,224L344,224" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M350,224 L 358,224 Q 365,224 365,216 L 365,209" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,224 159,228 159,219" style="fill:rgb(0,0,0)"/>
<path d="M144,208 L 144,216 Q 144,224 155,224 L 165,224" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M186,201L193,201A15 15 0 0 0 208 186A15 15 0 0 0 193 171L186,171A15 15 0 0 0 171 186A15 15 0 0 0 186 201Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="189" y="186" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="225,186 214,190 214,181" style="fill:rgb(0,0,0)"/>
<path d="M208,186L219,186" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,201L262,201A15 15 0 0 0 277 186A15 15 0 0 0 262 171L240,171A15 15 0 0 0 225 186A15 15 0 0 0 240 201Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="251" y="186" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">FAIL</text>
<polygon points="350,186 339,190 339,181" style="fill:rgb(0,0,0)"/>
<path d="M277,186L344,186" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M350,186 L 358,186 Q 365,186 365,178 L 365,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,186 159,190 159,181" style="fill:rgb(0,0,0)"/>
<path d="M144,171 L 144,178 Q 144,186 155,186 L 165,186" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M186,163L193,163A15 15 0 0 0 208 148A15 15 0 0 0 193 133L186,133A15 15 0 0 0 171 148A15 15 0 0 0 186 163Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="189" y="148" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="225,148 214,152 214,144" style="fill:rgb(0,0,0)"/>
<path d="M208,148L219,148" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,163L282,163A15 15 0 0 0 297 148A15 15 0 0 0 282 133L240,133A15 15 0 0 0 225 148A15 15 0 0 0 240 163Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="261" y="148" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ABORT</text>
<polygon points="350,148 339,152 339,144" style="fill:rgb(0,0,0)"/>
<path d="M297,148L344,148" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M350,148 L 358,148 Q 365,148 365,140 L 365,133" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,148 159,152 159,144" style="fill:rgb(0,0,0)"/>
<path d="M144,133 L 144,140 Q 144,148 155,148 L 165,148" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="350,121 339,125 339,116" style="fill:rgb(0,0,0)"/>
<path d="M129,121L344,121" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M350,121L380,121" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,375 39,379 39,370" style="fill:rgb(0,0,0)"/>
<path d="M576,121 L 584,121 Q 591,121 591,136 L 591,322 Q 591,337 576,337 L 39,337 Q 24,337 24,352 L 24,360 Q 24,375 34,375 L 45,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M65,390L81,390A15 15 0 0 0 96 375A15 15 0 0 0 81 360L65,360A15 15 0 0 0 50 375A15 15 0 0 0 65 390Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="73" y="375" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">SET</text>
<polygon points="153,413 141,417 141,408" style="fill:rgb(0,0,0)"/>
<path d="M96,375 L 111,375 Q 126,375 126,390 L 126,398 Q 126,413 136,413 L 147,413" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M153,428L309,428L309,397L153,397Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="231" y="413" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name-list</text>
<polygon points="350,375 339,379 339,370" style="fill:rgb(0,0,0)"/>
<path d="M309,413 L 316,413 Q 324,413 324,398 L 324,390 Q 324,375 334,375 L 344,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M365,390A15 15 0 0 0 380 375A15 15 0 0 0 365 360A15 15 0 0 0 350 375A15 15 0 0 0 365 390Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="365" y="375" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">=</text>
<polygon points="404,375 392,379 392,370" style="fill:rgb(0,0,0)"/>
<path d="M380,375L398,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M404,390L453,390L453,360L404,360Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="428" y="375" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="153,375 141,379 141,370" style="fill:rgb(0,0,0)"/>
<path d="M96,375L147,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M168,390L262,390A15 15 0 0 0 277 375A15 15 0 0 0 262 360L168,360A15 15 0 0 0 153 375A15 15 0 0 0 168 390Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="215" y="375" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text>
<path d="M277,375L339,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M251,465A15 15 0 0 0 266 450A15 15 0 0 0 251 435A15 15 0 0 0 236 450A15 15 0 0 0 251 465Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="251" y="450" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="266,450 277,446 277,455" style="fill:rgb(0,0,0)"/>
<path d="M453,375 L 460,375 Q 468,375 468,390 L 468,435 Q 468,450 453,450 L 287,450 L 272,450" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M236,450 L 117,450 Q 102,450 102,435 L 102,390 Q 102,375 117,375 L 117,375 L 132,375" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="251,488 262,484 262,492" style="fill:rgb(0,0,0)"/>
<path d="M453,375 L 460,375 Q 468,375 468,390 L 468,473 Q 468,488 453,488 L 271,488 L 256,488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M251,488 L 39,488 Q 24,488 24,503 L 24,511 Q 24,526 37,526 L 50,526" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M65,541L100,541A15 15 0 0 0 115 526A15 15 0 0 0 100 511L65,511A15 15 0 0 0 50 526A15 15 0 0 0 65 541Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="83" y="526" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">FROM</text>
<polygon points="187,526 176,530 176,522" style="fill:rgb(0,0,0)"/>
<path d="M115,526L182,526" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M187,541L348,541L348,511L187,511Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="268" y="526" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-or-subquery</text>
<path d="M268,579A15 15 0 0 0 283 564A15 15 0 0 0 268 549A15 15 0 0 0 253 564A15 15 0 0 0 268 579Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="268" y="564" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="283,564 295,559 295,568" style="fill:rgb(0,0,0)"/>
<path d="M348,526 L 356,526 Q 363,526 363,541 L 363,549 Q 363,564 348,564 L 304,564 L 289,564" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M253,564 L 176,564 Q 161,564 161,549 L 161,541 Q 161,526 168,526 L 176,526" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="187,602 176,606 176,597" style="fill:rgb(0,0,0)"/>
<path d="M115,526 L 123,526 Q 130,526 130,541 L 130,587 Q 130,602 145,602 L 167,602 L 182,602" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M187,617L290,617L290,586L187,586Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="239" y="602" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">join-clause</text>
<polygon points="405,526 393,530 393,522" style="fill:rgb(0,0,0)"/>
<path d="M290,602 L 363,602 Q 378,602 378,587 L 378,541 Q 378,526 389,526 L 399,526" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="244,639 255,635 255,644" style="fill:rgb(0,0,0)"/>
<path d="M405,526 L 412,526 Q 420,526 420,541 L 420,624 Q 420,639 405,639 L 265,639 L 250,639" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M348,526L393,526" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,677 39,681 39,673" style="fill:rgb(0,0,0)"/>
<path d="M244,639 L 39,639 Q 24,639 24,654 L 24,662 Q 24,677 34,677 L 45,677" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M66,692L115,692A15 15 0 0 0 130 677A15 15 0 0 0 115 662L66,662A15 15 0 0 0 50 677A15 15 0 0 0 66 692Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="90" y="677" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WHERE</text>
<polygon points="153,677 142,681 142,673" style="fill:rgb(0,0,0)"/>
<path d="M130,677L147,677" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M153,692L202,692L202,662L153,662Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="178" y="677" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="24,586 20,575 28,575" style="fill:rgb(0,0,0)"/>
<path d="M24,511L24,581" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M24,586L24,662" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="613,715 602,719 602,711" style="fill:rgb(0,0,0)"/>
<path d="M24,662 L 24,700 Q 24,715 39,715 L 593,715 L 608,715" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<circle cx="617" cy="715" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="253,715 242,719 242,711" style="fill:rgb(0,0,0)"/>
<path d="M202,677 L 210,677 Q 217,677 217,692 L 217,700 Q 217,715 232,715 L 233,715 L 248,715" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="295,677 283,681 283,673" style="fill:rgb(0,0,0)"/>
<path d="M253,715 L 261,715 Q 268,715 268,700 L 268,692 Q 268,677 279,677 L 289,677" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M295,692L446,692L446,662L295,662Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="370" y="677" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">returning-clause</text>
<polygon points="497,715 485,719 485,711" style="fill:rgb(0,0,0)"/>
<path d="M446,677 L 453,677 Q 461,677 461,692 L 461,700 Q 461,715 476,715 L 476,715 L 491,715" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
</svg>
</div><br>
Used by: <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./sql-stmt.html'>sql-stmt</a><br></br>
References: <a href='./column-name-list.html'>column-name-list</a> <a href='./common-table-expression.html'>common-table-expression</a> <a href='./expr.html'>expr</a> <a href='./join-clause.html'>join-clause</a> <a href='./qualified-table-name.html'>qualified-table-name</a> <a href='./returning-clause.html'>returning-clause</a> <a href='./table-or-subquery.html'>table-or-subquery</a><br></br>
See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_update.html'>lang_update.html</a>
</div>
|
