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
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
<!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: insert-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'>insert-stmt</h1>
<div class='imgcontainer'>
<div style="max-width:601px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 601.066 922.104">
<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,145L124,145A15 15 0 0 0 139 130A15 15 0 0 0 124 115L60,115A15 15 0 0 0 45 130A15 15 0 0 0 60 145Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="92" y="130" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">REPLACE</text>
<path d="M60,183L109,183A15 15 0 0 0 124 168A15 15 0 0 0 109 153L60,153A15 15 0 0 0 45 168A15 15 0 0 0 60 183Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="84" y="168" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INSERT</text>
<polygon points="166,198 154,203 154,194" style="fill:rgb(0,0,0)"/>
<path d="M124,168 L 132,168 Q 139,168 139,183 L 139,183 Q 139,198 149,198 L 160,198" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M181,213L187,213A15 15 0 0 0 203 198A15 15 0 0 0 187 183L181,183A15 15 0 0 0 166 198A15 15 0 0 0 181 213Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="184" y="198" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OR</text>
<polygon points="244,349 233,354 233,345" style="fill:rgb(0,0,0)"/>
<path d="M203,198 L 210,198 Q 218,198 218,213 L 218,334 Q 218,349 228,349 L 238,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M259,365L337,365A15 15 0 0 0 352 349A15 15 0 0 0 337 334L259,334A15 15 0 0 0 244 349A15 15 0 0 0 259 365Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="298" y="349" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ROLLBACK</text>
<polygon points="369,349 358,354 358,345" style="fill:rgb(0,0,0)"/>
<path d="M352,349L363,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="411,130 399,135 399,126" style="fill:rgb(0,0,0)"/>
<path d="M369,349 L 377,349 Q 384,349 384,334 L 384,145 Q 384,130 395,130 L 405,130" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M426,145L453,145A15 15 0 0 0 468 130A15 15 0 0 0 453 115L426,115A15 15 0 0 0 411 130A15 15 0 0 0 426 145Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="439" y="130" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INTO</text>
<polygon points="45,168 33,172 33,164" style="fill:rgb(0,0,0)"/>
<path d="M24,53 L 24,153 Q 24,168 31,168 L 39,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,130 33,135 33,126" style="fill:rgb(0,0,0)"/>
<path d="M24,115 L 24,123 Q 24,130 31,130 L 39,130" 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);" />
<path d="M139,130L399,130" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="369,168 358,172 358,164" style="fill:rgb(0,0,0)"/>
<path d="M124,168L363,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M369,168 L 377,168 Q 384,168 384,160 L 384,153" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M259,213L301,213A15 15 0 0 0 316 198A15 15 0 0 0 301 183L259,183A15 15 0 0 0 244 198A15 15 0 0 0 259 213Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="280" y="198" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ABORT</text>
<polygon points="244,198 233,203 233,194" style="fill:rgb(0,0,0)"/>
<path d="M203,198L238,198" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="369,198 358,203 358,194" style="fill:rgb(0,0,0)"/>
<path d="M316,198L363,198" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M369,198 L 377,198 Q 384,198 384,191 L 384,183" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M259,251L281,251A15 15 0 0 0 296 236A15 15 0 0 0 281 221L259,221A15 15 0 0 0 244 236A15 15 0 0 0 259 251Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="270" y="236" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">FAIL</text>
<polygon points="244,236 233,240 233,232" style="fill:rgb(0,0,0)"/>
<path d="M218,221 L 218,228 Q 218,236 228,236 L 238,236" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="369,236 358,240 358,232" style="fill:rgb(0,0,0)"/>
<path d="M296,236L363,236" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M369,236 L 377,236 Q 384,236 384,229 L 384,221" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M259,289L311,289A15 15 0 0 0 327 274A15 15 0 0 0 311 259L259,259A15 15 0 0 0 244 274A15 15 0 0 0 259 289Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="285" y="274" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IGNORE</text>
<polygon points="244,274 233,278 233,270" style="fill:rgb(0,0,0)"/>
<path d="M218,259 L 218,266 Q 218,274 228,274 L 238,274" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="369,274 358,278 358,270" style="fill:rgb(0,0,0)"/>
<path d="M327,274L363,274" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M369,274 L 377,274 Q 384,274 384,266 L 384,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M259,327L323,327A15 15 0 0 0 338 312A15 15 0 0 0 323 297L259,297A15 15 0 0 0 244 312A15 15 0 0 0 259 327Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="291" y="312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">REPLACE</text>
<polygon points="244,312 233,316 233,307" style="fill:rgb(0,0,0)"/>
<path d="M218,297 L 218,304 Q 218,312 228,312 L 238,312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="369,312 358,316 358,307" style="fill:rgb(0,0,0)"/>
<path d="M338,312L363,312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M369,312 L 377,312 Q 384,312 384,304 L 384,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,455L156,455A15 15 0 0 0 171 440A15 15 0 0 0 156 425L60,425A15 15 0 0 0 45 440A15 15 0 0 0 60 455Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="108" y="440" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text>
<polygon points="195,440 183,444 183,436" style="fill:rgb(0,0,0)"/>
<path d="M171,440L189,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M210,455A15 15 0 0 0 225 440A15 15 0 0 0 210 425A15 15 0 0 0 195 440A15 15 0 0 0 210 455Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="210" y="440" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text>
<polygon points="261,440 249,444 249,436" style="fill:rgb(0,0,0)"/>
<path d="M225,440L255,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M276,455L351,455A15 15 0 0 0 366 440A15 15 0 0 0 351 425L276,425A15 15 0 0 0 261 440A15 15 0 0 0 276 455Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="313" y="440" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text>
<polygon points="402,440 391,444 391,436" style="fill:rgb(0,0,0)"/>
<path d="M366,440L396,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M417,455L421,455A15 15 0 0 0 436 440A15 15 0 0 0 421 425L417,425A15 15 0 0 0 402 440A15 15 0 0 0 417 455Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="419" y="440" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text>
<polygon points="459,440 448,444 448,436" style="fill:rgb(0,0,0)"/>
<path d="M436,440L454,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M475,455L495,455A15 15 0 0 0 510 440A15 15 0 0 0 495 425L475,425A15 15 0 0 0 459 440A15 15 0 0 0 475 455Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="485" y="440" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">alias</text>
<polygon points="483,238 478,227 487,227" style="fill:rgb(0,0,0)"/>
<path d="M468,130 L 475,130 Q 483,130 483,145 L 483,217 L 483,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="171,395 183,390 183,399" style="fill:rgb(0,0,0)"/>
<path d="M483,238 L 483,380 Q 483,395 468,395 L 192,395 L 177,395" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,440 33,444 33,436" style="fill:rgb(0,0,0)"/>
<path d="M171,395 L 35,395 Q 20,395 20,410 L 20,425 Q 20,440 30,440 L 39,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="234,423 230,412 239,412" style="fill:rgb(0,0,0)"/>
<path d="M261,395 L 247,395 Q 234,395 234,406 L 234,417" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M234,423 L 234,432 Q 234,440 242,440 L 249,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,546A15 15 0 0 0 75 531A15 15 0 0 0 60 516A15 15 0 0 0 45 531A15 15 0 0 0 60 546Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="60" y="531" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="111,531 100,535 100,527" style="fill:rgb(0,0,0)"/>
<path d="M75,531L105,531" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M126,546L220,546A15 15 0 0 0 235 531A15 15 0 0 0 220 516L126,516A15 15 0 0 0 111 531A15 15 0 0 0 126 546Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="173" y="531" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text>
<polygon points="271,531 260,535 260,527" style="fill:rgb(0,0,0)"/>
<path d="M235,531L266,531" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M287,546A15 15 0 0 0 302 531A15 15 0 0 0 287 516A15 15 0 0 0 271 531A15 15 0 0 0 287 546Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="287" y="531" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<path d="M173,580A15 15 0 0 0 188 565A15 15 0 0 0 173 550A15 15 0 0 0 158 565A15 15 0 0 0 173 580Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="173" y="565" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="188,565 200,561 200,569" style="fill:rgb(0,0,0)"/>
<path d="M235,531 L 243,531 Q 250,531 250,546 L 250,550 Q 250,565 235,565 L 209,565 L 194,565" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M158,565 L 100,565 Q 85,565 85,550 L 85,546 Q 85,531 92,531 L 100,531" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="173,595 185,591 185,599" style="fill:rgb(0,0,0)"/>
<path d="M302,531 L 309,531 Q 317,531 317,546 L 317,580 Q 317,595 302,595 L 194,595 L 179,595" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M173,595 L 39,595 Q 24,595 24,603 L 24,610" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="436,486 448,481 448,490" style="fill:rgb(0,0,0)"/>
<path d="M510,440 L 518,440 Q 525,440 525,455 L 525,471 Q 525,486 510,486 L 457,486 L 442,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,531 33,535 33,527" style="fill:rgb(0,0,0)"/>
<path d="M436,486 L 39,486 Q 24,486 24,501 L 24,516 Q 24,531 31,531 L 39,531" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="381,469 377,457 385,457" style="fill:rgb(0,0,0)"/>
<path d="M366,440 L 374,440 Q 381,440 381,451 L 381,463" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M381,469 L 381,477 Q 381,486 374,486 L 366,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,671L112,671A15 15 0 0 0 127 656A15 15 0 0 0 112 640L60,640A15 15 0 0 0 45 656A15 15 0 0 0 60 671Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="86" y="656" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VALUES</text>
<polygon points="163,656 152,660 152,651" style="fill:rgb(0,0,0)"/>
<path d="M127,656L158,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M179,671A15 15 0 0 0 194 656A15 15 0 0 0 179 640A15 15 0 0 0 163 656A15 15 0 0 0 179 671Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="179" y="656" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="230,656 218,660 218,651" style="fill:rgb(0,0,0)"/>
<path d="M194,656L224,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M230,671L279,671L279,640L230,640Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="254" y="656" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="315,656 303,660 303,651" style="fill:rgb(0,0,0)"/>
<path d="M279,656L309,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M330,671A15 15 0 0 0 345 656A15 15 0 0 0 330 640A15 15 0 0 0 315 656A15 15 0 0 0 330 671Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="330" y="656" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="45,656 33,660 33,651" style="fill:rgb(0,0,0)"/>
<path d="M24,516 L 24,641 Q 24,656 31,656 L 39,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M254,705A15 15 0 0 0 269 690A15 15 0 0 0 254 675A15 15 0 0 0 239 690A15 15 0 0 0 254 705Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="254" y="690" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="269,690 281,685 281,694" style="fill:rgb(0,0,0)"/>
<path d="M279,656 L 286,656 Q 294,656 294,671 L 294,675 Q 294,690 285,690 L 275,690" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M239,690 L 218,690 Q 203,690 203,675 L 203,671 Q 203,656 211,656 L 218,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M254,743A15 15 0 0 0 269 727A15 15 0 0 0 254 712A15 15 0 0 0 239 727A15 15 0 0 0 254 743Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="254" y="727" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="269,727 281,723 281,732" style="fill:rgb(0,0,0)"/>
<path d="M345,656 L 353,656 Q 360,656 360,671 L 360,712 Q 360,727 345,727 L 290,727 L 275,727" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M239,727 L 152,727 Q 137,727 137,712 L 137,671 Q 137,656 144,656 L 152,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="387,693 375,698 375,689" style="fill:rgb(0,0,0)"/>
<path d="M345,656 L 353,656 Q 360,656 360,671 L 360,678 Q 360,693 371,693 L 381,693" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M387,709L512,709L512,678L387,678Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="449" y="693" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">upsert-clause</text>
<polygon points="535,693 523,698 523,689" style="fill:rgb(0,0,0)"/>
<path d="M512,693L529,693" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M535,693 L 542,693 Q 550,693 550,701 L 550,708" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="535,656 523,660 523,651" style="fill:rgb(0,0,0)"/>
<path d="M345,656L529,656" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M45,788L149,788L149,758L45,758Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="97" y="773" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-stmt</text>
<polygon points="535,773 523,777 523,768" style="fill:rgb(0,0,0)"/>
<path d="M149,773L529,773" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M535,773 L 542,773 Q 550,773 550,780 L 550,788" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,773 33,777 33,768" style="fill:rgb(0,0,0)"/>
<path d="M24,640 L 24,758 Q 24,773 31,773 L 39,773" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M387,818L512,818L512,788L387,788Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="449" y="803" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">upsert-clause</text>
<polygon points="535,803 523,807 523,799" style="fill:rgb(0,0,0)"/>
<path d="M512,803L529,803" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M535,803 L 542,803 Q 550,803 550,811 L 550,818" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="387,803 375,807 375,799" style="fill:rgb(0,0,0)"/>
<path d="M345,773 L 353,773 Q 360,773 360,788 L 360,788 Q 360,803 371,803 L 381,803" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M60,856L125,856A15 15 0 0 0 140 841A15 15 0 0 0 125 826L60,826A15 15 0 0 0 45 841A15 15 0 0 0 60 856Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="93" y="841" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DEFAULT</text>
<polygon points="164,841 152,845 152,837" style="fill:rgb(0,0,0)"/>
<path d="M140,841L158,841" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M179,856L231,856A15 15 0 0 0 246 841A15 15 0 0 0 231 826L179,826A15 15 0 0 0 164 841A15 15 0 0 0 179 856Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="205" y="841" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VALUES</text>
<polygon points="535,841 523,845 523,837" style="fill:rgb(0,0,0)"/>
<path d="M246,841L529,841" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,841 33,845 33,837" style="fill:rgb(0,0,0)"/>
<path d="M24,758 L 24,826 Q 24,841 31,841 L 39,841" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M361,919L512,919L512,889L361,889Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="436" y="904" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">returning-clause</text>
<polygon points="591,904 580,909 580,900" style="fill:rgb(0,0,0)"/>
<path d="M512,904L585,904" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<circle cx="595" cy="904" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M535,656 L 542,656 Q 550,656 550,671 L 550,889 Q 550,904 557,904 L 565,904" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="436,871 448,867 448,875" style="fill:rgb(0,0,0)"/>
<path d="M535,841 L 542,841 Q 550,841 550,856 L 550,856 Q 550,871 535,871 L 457,871 L 442,871" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="361,904 349,909 349,900" style="fill:rgb(0,0,0)"/>
<path d="M436,871 L 349,871 Q 334,871 334,886 L 334,889 Q 334,904 345,904 L 355,904" 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='./common-table-expression.html'>common-table-expression</a> <a href='./expr.html'>expr</a> <a href='./returning-clause.html'>returning-clause</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./upsert-clause.html'>upsert-clause</a><br></br>
See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_insert.html'>lang_insert.html</a>
</div>
|
