| 1 |
<!DOCTYPE html> |
| 2 |
<html><head> |
| 3 |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| 4 |
<meta http-equiv="content-type" content="text/html; charset=UTF-8"> |
| 5 |
<link href="../sqlite.css" rel="stylesheet"> |
| 6 |
<title>SQLite Syntax: create-trigger-stmt</title> |
| 7 |
<!-- path=../ --> |
| 8 |
</head> |
| 9 |
<body> |
| 10 |
<div class=nosearch> |
| 11 |
<a href="../index.html"> |
| 12 |
<img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0"> |
| 13 |
</a> |
| 14 |
<div><!-- IE hack to prevent disappearing logo --></div> |
| 15 |
<div class="tagline desktoponly"> |
| 16 |
Small. Fast. Reliable.<br>Choose any three. |
| 17 |
</div> |
| 18 |
<div class="menu mainmenu"> |
| 19 |
<ul> |
| 20 |
<li><a href="../index.html">Home</a> |
| 21 |
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a> |
| 22 |
<li class='wideonly'><a href='../about.html'>About</a> |
| 23 |
<li class='desktoponly'><a href="../docs.html">Documentation</a> |
| 24 |
<li class='desktoponly'><a href="../download.html">Download</a> |
| 25 |
<li class='wideonly'><a href='../copyright.html'>License</a> |
| 26 |
<li class='desktoponly'><a href="../support.html">Support</a> |
| 27 |
<li class='desktoponly'><a href="../prosupport.html">Purchase</a> |
| 28 |
<li class='search' id='search_menubutton'> |
| 29 |
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a> |
| 30 |
</ul> |
| 31 |
</div> |
| 32 |
<div class="menu submenu" id="submenu"> |
| 33 |
<ul> |
| 34 |
<li><a href='../about.html'>About</a> |
| 35 |
<li><a href='../docs.html'>Documentation</a> |
| 36 |
<li><a href='../download.html'>Download</a> |
| 37 |
<li><a href='../support.html'>Support</a> |
| 38 |
<li><a href='../prosupport.html'>Purchase</a> |
| 39 |
</ul> |
| 40 |
</div> |
| 41 |
<div class="searchmenu" id="searchmenu"> |
| 42 |
<form method="GET" action="../search"> |
| 43 |
<select name="s" id="searchtype"> |
| 44 |
<option value="d">Search Documentation</option> |
| 45 |
<option value="c">Search Changelog</option> |
| 46 |
</select> |
| 47 |
<input type="text" name="q" id="searchbox" value=""> |
| 48 |
<input type="submit" value="Go"> |
| 49 |
</form> |
| 50 |
</div> |
| 51 |
</div> |
| 52 |
<script> |
| 53 |
function toggle_div(nm) { |
| 54 |
var w = document.getElementById(nm); |
| 55 |
if( w.style.display=="block" ){ |
| 56 |
w.style.display = "none"; |
| 57 |
}else{ |
| 58 |
w.style.display = "block"; |
| 59 |
} |
| 60 |
} |
| 61 |
function toggle_search() { |
| 62 |
var w = document.getElementById("searchmenu"); |
| 63 |
if( w.style.display=="block" ){ |
| 64 |
w.style.display = "none"; |
| 65 |
} else { |
| 66 |
w.style.display = "block"; |
| 67 |
setTimeout(function(){ |
| 68 |
document.getElementById("searchbox").focus() |
| 69 |
}, 30); |
| 70 |
} |
| 71 |
} |
| 72 |
function div_off(nm){document.getElementById(nm).style.display="none";} |
| 73 |
window.onbeforeunload = function(e){div_off("submenu");} |
| 74 |
/* Disable the Search feature if we are not operating from CGI, since */ |
| 75 |
/* Search is accomplished using CGI and will not work without it. */ |
| 76 |
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){ |
| 77 |
document.getElementById("search_menubutton").style.display = "none"; |
| 78 |
} |
| 79 |
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */ |
| 80 |
function hideorshow(btn,obj){ |
| 81 |
var x = document.getElementById(obj); |
| 82 |
var b = document.getElementById(btn); |
| 83 |
if( x.style.display!='none' ){ |
| 84 |
x.style.display = 'none'; |
| 85 |
b.innerHTML='show'; |
| 86 |
}else{ |
| 87 |
x.style.display = ''; |
| 88 |
b.innerHTML='hide'; |
| 89 |
} |
| 90 |
return false; |
| 91 |
} |
| 92 |
var antiRobot = 0; |
| 93 |
function antiRobotGo(){ |
| 94 |
if( antiRobot!=3 ) return; |
| 95 |
antiRobot = 7; |
| 96 |
var j = document.getElementById("mtimelink"); |
| 97 |
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href"); |
| 98 |
} |
| 99 |
function antiRobotDefense(){ |
| 100 |
document.body.onmousedown=function(){ |
| 101 |
antiRobot |= 2; |
| 102 |
antiRobotGo(); |
| 103 |
document.body.onmousedown=null; |
| 104 |
} |
| 105 |
document.body.onmousemove=function(){ |
| 106 |
antiRobot |= 2; |
| 107 |
antiRobotGo(); |
| 108 |
document.body.onmousemove=null; |
| 109 |
} |
| 110 |
setTimeout(function(){ |
| 111 |
antiRobot |= 1; |
| 112 |
antiRobotGo(); |
| 113 |
}, 100) |
| 114 |
antiRobotGo(); |
| 115 |
} |
| 116 |
antiRobotDefense(); |
| 117 |
</script> |
| 118 |
<h1 align='center'>create-trigger-stmt</h1> |
| 119 |
<div class='imgcontainer'> |
| 120 |
<div style="max-width:678px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 678.058 746.712" data-pikchr-date="20250319161943"> |
| 121 |
<circle cx="5.76" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 122 |
<polygon points="32.4,17.28 20.88,21.6 20.88,12.96" style="fill:rgb(0,0,0)"/> |
| 123 |
<path d="M9.36,17.28L26.64,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 124 |
<path d="M47.52,32.4L100.915,32.4A15.12 15.12 0 0 0 116.035 17.28A15.12 15.12 0 0 0 100.915 2.16L47.52,2.16A15.12 15.12 0 0 0 32.4 17.28A15.12 15.12 0 0 0 47.52 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 125 |
<text x="74.2176" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CREATE</text> |
| 126 |
<path d="M167.155,56.592L199.354,56.592A15.12 15.12 0 0 0 214.474 41.472A15.12 15.12 0 0 0 199.354 26.352L167.155,26.352A15.12 15.12 0 0 0 152.035 41.472A15.12 15.12 0 0 0 167.155 56.592Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 127 |
<text x="183.254" y="41.472" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TEMP</text> |
| 128 |
<path d="M167.155,94.392L259.718,94.392A15.12 15.12 0 0 0 274.838 79.272A15.12 15.12 0 0 0 259.718 64.152L167.155,64.152A15.12 15.12 0 0 0 152.035 79.272A15.12 15.12 0 0 0 167.155 94.392Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 129 |
<text x="213.437" y="79.272" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TEMPORARY</text> |
| 130 |
<path d="M325.958,32.4L386.035,32.4A15.12 15.12 0 0 0 401.155 17.28A15.12 15.12 0 0 0 386.035 2.16L325.958,2.16A15.12 15.12 0 0 0 310.838 17.28A15.12 15.12 0 0 0 325.958 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 131 |
<text x="355.997" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TRIGGER</text> |
| 132 |
<polygon points="213.437,17.28 201.917,21.6 201.917,12.96" style="fill:rgb(0,0,0)"/> |
| 133 |
<path d="M116.035,17.28L207.677,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 134 |
<polygon points="310.838,17.28 299.318,21.6 299.318,12.96" style="fill:rgb(0,0,0)"/> |
| 135 |
<path d="M213.437,17.28L305.078,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 136 |
<polygon points="152.035,41.472 140.515,45.792 140.515,37.152" style="fill:rgb(0,0,0)"/> |
| 137 |
<path d="M116.035,17.28 L 123.535,17.28 Q 131.035,17.28 131.035,29.376 Q 131.035,41.472 138.655,41.472 L 146.275,41.472" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 138 |
<polygon points="152.035,79.272 140.515,83.592 140.515,74.952" style="fill:rgb(0,0,0)"/> |
| 139 |
<path d="M116.035,17.28 L 123.535,17.28 Q 131.035,17.28 131.035,32.28 L 131.035,64.272 Q 131.035,79.272 138.655,79.272 L 146.275,79.272" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 140 |
<path d="M274.838,79.272 L 282.338,79.272 Q 289.838,79.272 289.838,64.272 L 289.838,32.28 Q 289.838,17.28 294.578,17.28 L 299.318,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 141 |
<path d="M214.474,41.472 L 274.838,41.472 Q 289.838,41.472 289.838,33.972 L 289.838,26.472" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 142 |
<polygon points="437.155,17.28 425.635,21.6 425.635,12.96" style="fill:rgb(0,0,0)"/> |
| 143 |
<path d="M401.155,17.28L431.395,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 144 |
<path d="M452.275,32.4A15.12 15.12 0 0 0 467.395 17.28A15.12 15.12 0 0 0 452.275 2.16A15.12 15.12 0 0 0 437.155 17.28A15.12 15.12 0 0 0 452.275 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 145 |
<text x="452.275" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IF</text> |
| 146 |
<polygon points="490.435,17.28 478.915,21.6 478.915,12.96" style="fill:rgb(0,0,0)"/> |
| 147 |
<path d="M467.395,17.28L484.675,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 148 |
<path d="M505.555,32.4L525.658,32.4A15.12 15.12 0 0 0 540.778 17.28A15.12 15.12 0 0 0 525.658 2.16L505.555,2.16A15.12 15.12 0 0 0 490.435 17.28A15.12 15.12 0 0 0 505.555 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 149 |
<text x="515.606" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text> |
| 150 |
<polygon points="563.818,17.28 552.298,21.6 552.298,12.96" style="fill:rgb(0,0,0)"/> |
| 151 |
<path d="M540.778,17.28L558.058,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 152 |
<path d="M578.938,32.4L623.578,32.4A15.12 15.12 0 0 0 638.698 17.28A15.12 15.12 0 0 0 623.578 2.16L578.938,2.16A15.12 15.12 0 0 0 563.818 17.28A15.12 15.12 0 0 0 578.938 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 153 |
<text x="601.258" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXISTS</text> |
| 154 |
<polygon points="213.437,109.512 224.957,105.192 224.957,113.832" style="fill:rgb(0,0,0)"/> |
| 155 |
<path d="M401.155,17.28 L 408.655,17.28 Q 416.155,17.28 416.155,32.28 L 416.155,94.512 Q 416.155,109.512 401.155,109.512 L 234.197,109.512 L 219.197,109.512" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 156 |
<polygon points="563.818,109.512 575.338,105.192 575.338,113.832" style="fill:rgb(0,0,0)"/> |
| 157 |
<path d="M638.698,17.28 L 646.198,17.28 Q 653.698,17.28 653.698,32.28 L 653.698,94.512 Q 653.698,109.512 638.698,109.512 L 584.578,109.512 L 569.578,109.512" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 158 |
<path d="M563.818,109.512L310.838,109.512" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 159 |
<polygon points="28.8,147.312 17.28,151.632 17.28,142.992" style="fill:rgb(0,0,0)"/> |
| 160 |
<path d="M310.838,109.512 L 20.76,109.512 Q 5.76,109.512 5.76,124.512 L 5.76,132.312 Q 5.76,147.312 14.4,147.312 L 23.04,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 161 |
<path d="M43.92,162.432L140.285,162.432A15.12 15.12 0 0 0 155.405 147.312A15.12 15.12 0 0 0 140.285 132.192L43.92,132.192A15.12 15.12 0 0 0 28.8 147.312A15.12 15.12 0 0 0 43.92 162.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 162 |
<text x="92.1024" y="147.312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text> |
| 163 |
<polygon points="178.445,147.312 166.925,151.632 166.925,142.992" style="fill:rgb(0,0,0)"/> |
| 164 |
<path d="M155.405,147.312L172.685,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 165 |
<path d="M193.565,162.432A15.12 15.12 0 0 0 208.685 147.312A15.12 15.12 0 0 0 193.565 132.192A15.12 15.12 0 0 0 178.445 147.312A15.12 15.12 0 0 0 193.565 162.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 166 |
<text x="193.565" y="147.312" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text> |
| 167 |
<polygon points="244.685,147.312 233.165,151.632 233.165,142.992" style="fill:rgb(0,0,0)"/> |
| 168 |
<path d="M208.685,147.312L238.925,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 169 |
<path d="M259.805,162.432L351.446,162.432A15.12 15.12 0 0 0 366.566 147.312A15.12 15.12 0 0 0 351.446 132.192L259.805,132.192A15.12 15.12 0 0 0 244.685 147.312A15.12 15.12 0 0 0 259.805 162.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 170 |
<text x="305.626" y="147.312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">trigger-name</text> |
| 171 |
<polygon points="402.566,147.312 391.046,151.632 391.046,142.992" style="fill:rgb(0,0,0)"/> |
| 172 |
<path d="M366.566,147.312L396.806,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 173 |
<path d="M417.686,162.432L472.118,162.432A15.12 15.12 0 0 0 487.238 147.312A15.12 15.12 0 0 0 472.118 132.192L417.686,132.192A15.12 15.12 0 0 0 402.566 147.312A15.12 15.12 0 0 0 417.686 162.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 174 |
<text x="444.902" y="147.312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">BEFORE</text> |
| 175 |
<path d="M417.686,200.232L457.603,200.232A15.12 15.12 0 0 0 472.723 185.112A15.12 15.12 0 0 0 457.603 169.992L417.686,169.992A15.12 15.12 0 0 0 402.566 185.112A15.12 15.12 0 0 0 417.686 200.232Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 176 |
<text x="437.645" y="185.112" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AFTER</text> |
| 177 |
<path d="M417.686,238.032L479.261,238.032A15.12 15.12 0 0 0 494.381 222.912A15.12 15.12 0 0 0 479.261 207.792L417.686,207.792A15.12 15.12 0 0 0 402.566 222.912A15.12 15.12 0 0 0 417.686 238.032Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 178 |
<text x="448.474" y="222.912" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INSTEAD</text> |
| 179 |
<polygon points="517.421,222.912 505.901,227.232 505.901,218.592" style="fill:rgb(0,0,0)"/> |
| 180 |
<path d="M494.381,222.912L511.661,222.912" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 181 |
<path d="M532.541,238.032L538.358,238.032A15.12 15.12 0 0 0 553.478 222.912A15.12 15.12 0 0 0 538.358 207.792L532.541,207.792A15.12 15.12 0 0 0 517.421 222.912A15.12 15.12 0 0 0 532.541 238.032Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 182 |
<text x="535.45" y="222.912" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OF</text> |
| 183 |
<polygon points="402.566,185.112 391.046,189.432 391.046,180.792" style="fill:rgb(0,0,0)"/> |
| 184 |
<path d="M366.566,147.312 L 374.066,147.312 Q 381.566,147.312 381.566,162.312 L 381.566,170.112 Q 381.566,185.112 389.186,185.112 L 396.806,185.112" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 185 |
<polygon points="402.566,222.912 391.046,227.232 391.046,218.592" style="fill:rgb(0,0,0)"/> |
| 186 |
<path d="M366.566,147.312 L 374.066,147.312 Q 381.566,147.312 381.566,162.312 L 381.566,207.912 Q 381.566,222.912 389.186,222.912 L 396.806,222.912" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 187 |
<polygon points="92.1024,177.552 80.5824,181.872 80.5824,173.232" style="fill:rgb(0,0,0)"/> |
| 188 |
<path d="M5.76,132.192 L 5.76,162.552 Q 5.76,177.552 20.76,177.552 L 71.3424,177.552 L 86.3424,177.552" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 189 |
<path d="M92.1024,177.552 L 205.205,177.552 Q 220.205,177.552 220.205,162.552 L 220.205,162.312 Q 220.205,147.312 227.705,147.312 L 235.205,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 190 |
<polygon points="193.565,260.712 205.085,256.392 205.085,265.032" style="fill:rgb(0,0,0)"/> |
| 191 |
<path d="M381.566,207.792 L 381.566,245.712 Q 381.566,260.712 366.566,260.712 L 214.325,260.712 L 199.325,260.712" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 192 |
<polygon points="576.518,222.912 564.998,227.232 564.998,218.592" style="fill:rgb(0,0,0)"/> |
| 193 |
<path d="M553.478,222.912L570.758,222.912" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 194 |
<polygon points="448.474,260.712 459.994,256.392 459.994,265.032" style="fill:rgb(0,0,0)"/> |
| 195 |
<path d="M576.518,222.912 L 584.018,222.912 Q 591.518,222.912 591.518,237.912 L 591.518,245.712 Q 591.518,260.712 576.518,260.712 L 469.234,260.712 L 454.234,260.712" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 196 |
<path d="M448.474,260.712L366.566,260.712" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 197 |
<polygon points="576.518,147.312 564.998,151.632 564.998,142.992" style="fill:rgb(0,0,0)"/> |
| 198 |
<path d="M487.238,147.312L570.758,147.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 199 |
<path d="M576.518,147.312 L 584.018,147.312 Q 591.518,147.312 591.518,162.312 L 591.518,223.032 L 591.518,238.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 200 |
<polygon points="576.518,185.112 564.998,189.432 564.998,180.792" style="fill:rgb(0,0,0)"/> |
| 201 |
<path d="M472.723,185.112L570.758,185.112" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 202 |
<path d="M576.518,185.112 L 584.018,185.112 Q 591.518,185.112 591.518,192.612 L 591.518,200.112" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 203 |
<path d="M43.92,306.072L96.8544,306.072A15.12 15.12 0 0 0 111.974 290.952L111.974,290.952A15.12 15.12 0 0 0 96.8544 275.832L43.92,275.832A15.12 15.12 0 0 0 28.8 290.952L28.8,290.952A15.12 15.12 0 0 0 43.92 306.072Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 204 |
<text x="70.3872" y="290.952" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DELETE</text> |
| 205 |
<path d="M43.92,343.872L92.8224,343.872A15.12 15.12 0 0 0 107.942 328.752A15.12 15.12 0 0 0 92.8224 313.632L43.92,313.632A15.12 15.12 0 0 0 28.8 328.752A15.12 15.12 0 0 0 43.92 343.872Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 206 |
<text x="68.3712" y="328.752" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INSERT</text> |
| 207 |
<path d="M43.92,381.672L98.0064,381.672A15.12 15.12 0 0 0 113.126 366.552A15.12 15.12 0 0 0 98.0064 351.432L43.92,351.432A15.12 15.12 0 0 0 28.8 366.552A15.12 15.12 0 0 0 43.92 381.672Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 208 |
<text x="70.9632" y="366.552" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UPDATE</text> |
| 209 |
<polygon points="28.8,366.552 17.28,370.872 17.28,362.232" style="fill:rgb(0,0,0)"/> |
| 210 |
<path d="M193.565,260.712 L 20.76,260.712 Q 5.76,260.712 5.76,275.712 L 5.76,351.552 Q 5.76,366.552 14.4,366.552 L 23.04,366.552" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 211 |
<polygon points="28.8,290.952 17.28,295.272 17.28,286.632" style="fill:rgb(0,0,0)"/> |
| 212 |
<path d="M5.76,275.832 L 5.76,283.392 Q 5.76,290.952 14.4,290.952 L 23.04,290.952" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 213 |
<polygon points="28.8,328.752 17.28,333.072 17.28,324.432" style="fill:rgb(0,0,0)"/> |
| 214 |
<path d="M5.76,313.632 L 5.76,321.192 Q 5.76,328.752 14.4,328.752 L 23.04,328.752" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 215 |
<path d="M164.246,411.912L170.064,411.912A15.12 15.12 0 0 0 185.184 396.792A15.12 15.12 0 0 0 170.064 381.672L164.246,381.672A15.12 15.12 0 0 0 149.126 396.792A15.12 15.12 0 0 0 164.246 411.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 216 |
<text x="167.155" y="396.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OF</text> |
| 217 |
<polygon points="221.184,396.792 209.664,401.112 209.664,392.472" style="fill:rgb(0,0,0)"/> |
| 218 |
<path d="M185.184,396.792L215.424,396.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 219 |
<path d="M236.304,411.912L330.365,411.912A15.12 15.12 0 0 0 345.485 396.792A15.12 15.12 0 0 0 330.365 381.672L236.304,381.672A15.12 15.12 0 0 0 221.184 396.792A15.12 15.12 0 0 0 236.304 411.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 220 |
<text x="283.334" y="396.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text> |
| 221 |
<path d="M283.334,449.712L283.334,449.712A15.12 15.12 0 0 0 298.454 434.592A15.12 15.12 0 0 0 283.334 419.472L283.334,419.472A15.12 15.12 0 0 0 268.214 434.592A15.12 15.12 0 0 0 283.334 449.712Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 222 |
<text x="283.334" y="434.592" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> |
| 223 |
<polygon points="381.485,396.792 369.965,401.112 369.965,392.472" style="fill:rgb(0,0,0)"/> |
| 224 |
<path d="M345.485,396.792L375.725,396.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 225 |
<polygon points="419.525,290.952 408.005,295.272 408.005,286.632" style="fill:rgb(0,0,0)"/> |
| 226 |
<path d="M381.485,396.792 L 388.985,396.792 Q 396.485,396.792 396.485,381.792 L 396.485,305.952 Q 396.485,290.952 405.125,290.952 L 413.765,290.952" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 227 |
<path d="M434.645,306.072L443.573,306.072A15.12 15.12 0 0 0 458.693 290.952L458.693,290.952A15.12 15.12 0 0 0 443.573 275.832L434.645,275.832A15.12 15.12 0 0 0 419.525 290.952L419.525,290.952A15.12 15.12 0 0 0 434.645 306.072Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 228 |
<text x="439.109" y="290.952" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ON</text> |
| 229 |
<polygon points="481.733,290.952 470.213,295.272 470.213,286.632" style="fill:rgb(0,0,0)"/> |
| 230 |
<path d="M458.693,290.952L475.973,290.952" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 231 |
<path d="M496.853,306.072L572.021,306.072A15.12 15.12 0 0 0 587.141 290.952L587.141,290.952A15.12 15.12 0 0 0 572.021 275.832L496.853,275.832A15.12 15.12 0 0 0 481.733 290.952L481.733,290.952A15.12 15.12 0 0 0 496.853 306.072Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 232 |
<text x="534.437" y="290.952" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text> |
| 233 |
<path d="M111.974,290.952L408.005,290.952" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 234 |
<polygon points="381.485,328.752 369.965,333.072 369.965,324.432" style="fill:rgb(0,0,0)"/> |
| 235 |
<path d="M107.942,328.752L375.725,328.752" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 236 |
<path d="M381.485,328.752 L 388.985,328.752 Q 396.485,328.752 396.485,321.252 L 396.485,313.752" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 237 |
<polygon points="381.485,366.552 369.965,370.872 369.965,362.232" style="fill:rgb(0,0,0)"/> |
| 238 |
<path d="M113.126,366.552L375.725,366.552" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 239 |
<path d="M381.485,366.552 L 388.985,366.552 Q 396.485,366.552 396.485,359.052 L 396.485,351.552" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 240 |
<polygon points="149.126,396.792 137.606,401.112 137.606,392.472" style="fill:rgb(0,0,0)"/> |
| 241 |
<path d="M113.126,366.552 L 120.626,366.552 Q 128.126,366.552 128.126,381.552 L 128.126,381.792 Q 128.126,396.792 135.746,396.792 L 143.366,396.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 242 |
<polygon points="298.454,434.592 309.974,430.272 309.974,438.912" style="fill:rgb(0,0,0)"/> |
| 243 |
<path d="M345.485,396.792 L 352.985,396.792 Q 360.485,396.792 360.485,411.792 L 360.485,419.592 Q 360.485,434.592 345.485,434.592 L 319.214,434.592 L 304.214,434.592" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 244 |
<path d="M268.214,434.592 L 213.144,434.592 Q 198.144,434.592 198.144,419.592 L 198.144,411.792 Q 198.144,396.792 205.644,396.792 L 213.144,396.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 245 |
<path d="M43.92,525.312L62.064,525.312A15.12 15.12 0 0 0 77.184 510.192A15.12 15.12 0 0 0 62.064 495.072L43.92,495.072A15.12 15.12 0 0 0 28.8 510.192A15.12 15.12 0 0 0 43.92 525.312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 246 |
<text x="52.992" y="510.192" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">FOR</text> |
| 247 |
<polygon points="100.224,510.192 88.704,514.512 88.704,505.872" style="fill:rgb(0,0,0)"/> |
| 248 |
<path d="M77.184,510.192L94.464,510.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 249 |
<path d="M115.344,525.312L147.542,525.312A15.12 15.12 0 0 0 162.662 510.192A15.12 15.12 0 0 0 147.542 495.072L115.344,495.072A15.12 15.12 0 0 0 100.224 510.192A15.12 15.12 0 0 0 115.344 525.312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 250 |
<text x="131.443" y="510.192" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EACH</text> |
| 251 |
<polygon points="185.702,510.192 174.182,514.512 174.182,505.872" style="fill:rgb(0,0,0)"/> |
| 252 |
<path d="M162.662,510.192L179.942,510.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 253 |
<path d="M200.822,525.312L224.957,525.312A15.12 15.12 0 0 0 240.077 510.192A15.12 15.12 0 0 0 224.957 495.072L200.822,495.072A15.12 15.12 0 0 0 185.702 510.192A15.12 15.12 0 0 0 200.822 525.312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 254 |
<text x="212.89" y="510.192" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ROW</text> |
| 255 |
<polygon points="312.077,510.192 300.557,514.512 300.557,505.872" style="fill:rgb(0,0,0)"/> |
| 256 |
<path d="M240.077,510.192L306.317,510.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 257 |
<path d="M327.197,525.312L366.653,525.312A15.12 15.12 0 0 0 381.773 510.192A15.12 15.12 0 0 0 366.653 495.072L327.197,495.072A15.12 15.12 0 0 0 312.077 510.192A15.12 15.12 0 0 0 327.197 525.312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 258 |
<text x="346.925" y="510.192" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WHEN</text> |
| 259 |
<polygon points="404.813,510.192 393.293,514.512 393.293,505.872" style="fill:rgb(0,0,0)"/> |
| 260 |
<path d="M381.773,510.192L399.053,510.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 261 |
<path d="M404.813,525.312L454.003,525.312L454.003,495.072L404.813,495.072Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 262 |
<text x="429.408" y="510.192" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> |
| 263 |
<path d="M43.92,631.152L82.5696,631.152A15.12 15.12 0 0 0 97.6896 616.032A15.12 15.12 0 0 0 82.5696 600.912L43.92,600.912A15.12 15.12 0 0 0 28.8 616.032A15.12 15.12 0 0 0 43.92 631.152Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 264 |
<text x="63.2448" y="616.032" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">BEGIN</text> |
| 265 |
<polygon points="169.69,616.032 158.17,620.352 158.17,611.712" style="fill:rgb(0,0,0)"/> |
| 266 |
<path d="M97.6896,616.032L163.93,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 267 |
<path d="M169.69,631.152L282.47,631.152L282.47,600.912L169.69,600.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 268 |
<text x="226.08" y="616.032" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">update-stmt</text> |
| 269 |
<polygon points="336.47,616.032 324.95,620.352 324.95,611.712" style="fill:rgb(0,0,0)"/> |
| 270 |
<path d="M282.47,616.032L330.71,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 271 |
<path d="M351.59,631.152A15.12 15.12 0 0 0 366.71 616.032A15.12 15.12 0 0 0 351.59 600.912A15.12 15.12 0 0 0 336.47 616.032A15.12 15.12 0 0 0 351.59 631.152Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 272 |
<text x="351.59" y="616.032" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">;</text> |
| 273 |
<polygon points="402.71,616.032 391.19,620.352 391.19,611.712" style="fill:rgb(0,0,0)"/> |
| 274 |
<path d="M366.71,616.032L396.95,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 275 |
<path d="M417.83,631.152L438.854,631.152A15.12 15.12 0 0 0 453.974 616.032A15.12 15.12 0 0 0 438.854 600.912L417.83,600.912A15.12 15.12 0 0 0 402.71 616.032A15.12 15.12 0 0 0 417.83 631.152Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 276 |
<text x="428.342" y="616.032" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">END</text> |
| 277 |
<polygon points="668.698,616.032 657.178,620.352 657.178,611.712" style="fill:rgb(0,0,0)"/> |
| 278 |
<path d="M453.974,616.032L662.938,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 279 |
<circle cx="672.298" cy="616.032" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 280 |
<path d="M169.69,668.952L273.37,668.952L273.37,638.712L169.69,638.712Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 281 |
<text x="221.53" y="653.832" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">insert-stmt</text> |
| 282 |
<path d="M169.69,706.752L276.48,706.752L276.48,676.512L169.69,676.512Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 283 |
<text x="223.085" y="691.632" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">delete-stmt</text> |
| 284 |
<path d="M169.69,744.552L273.946,744.552L273.946,714.312L169.69,714.312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 285 |
<text x="221.818" y="729.432" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-stmt</text> |
| 286 |
<polygon points="169.69,729.432 158.17,733.752 158.17,725.112" style="fill:rgb(0,0,0)"/> |
| 287 |
<path d="M131.65,616.032 L 139.15,616.032 Q 146.65,616.032 146.65,631.032 L 146.65,714.432 Q 146.65,729.432 155.29,729.432 L 163.93,729.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 288 |
<polygon points="169.69,653.832 158.17,658.152 158.17,649.512" style="fill:rgb(0,0,0)"/> |
| 289 |
<path d="M146.65,638.712 L 146.65,646.272 Q 146.65,653.832 155.29,653.832 L 163.93,653.832" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 290 |
<polygon points="169.69,691.632 158.17,695.952 158.17,687.312" style="fill:rgb(0,0,0)"/> |
| 291 |
<path d="M146.65,676.512 L 146.65,684.072 Q 146.65,691.632 155.29,691.632 L 163.93,691.632" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 292 |
<polygon points="298.43,729.432 286.91,733.752 286.91,725.112" style="fill:rgb(0,0,0)"/> |
| 293 |
<path d="M273.946,729.432L292.67,729.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 294 |
<path d="M298.43,729.432 L 305.93,729.432 Q 313.43,729.432 313.43,714.432 L 313.43,631.032 Q 313.43,616.032 319.19,616.032 L 324.95,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 295 |
<polygon points="298.43,653.832 286.91,658.152 286.91,649.512" style="fill:rgb(0,0,0)"/> |
| 296 |
<path d="M273.37,653.832L292.67,653.832" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 297 |
<path d="M298.43,653.832 L 305.93,653.832 Q 313.43,653.832 313.43,646.332 L 313.43,638.832" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 298 |
<polygon points="298.43,691.632 286.91,695.952 286.91,687.312" style="fill:rgb(0,0,0)"/> |
| 299 |
<path d="M276.48,691.632L292.67,691.632" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 300 |
<path d="M298.43,691.632 L 305.93,691.632 Q 313.43,691.632 313.43,684.132 L 313.43,676.632" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 301 |
<polygon points="226.08,585.792 237.6,581.472 237.6,590.112" style="fill:rgb(0,0,0)"/> |
| 302 |
<path d="M366.71,616.032 L 374.21,616.032 Q 381.71,616.032 381.71,601.032 L 381.71,600.792 Q 381.71,585.792 366.71,585.792 L 246.84,585.792 L 231.84,585.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 303 |
<polygon points="132.25,616.032 120.73,620.352 120.73,611.712" style="fill:rgb(0,0,0)"/> |
| 304 |
<path d="M226.08,585.792 L 124.21,585.792 Q 109.21,585.792 109.21,600.792 L 109.21,601.032 Q 109.21,616.032 117.85,616.032 L 126.49,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 305 |
<polygon points="602.141,434.952 597.821,423.432 606.461,423.432" style="fill:rgb(0,0,0)"/> |
| 306 |
<path d="M587.141,290.952 L 594.641,290.952 Q 602.141,290.952 602.141,305.952 L 602.141,414.192 L 602.141,429.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 307 |
<polygon points="226.08,472.392 237.6,468.072 237.6,476.712" style="fill:rgb(0,0,0)"/> |
| 308 |
<path d="M602.141,434.952 L 602.141,457.392 Q 602.141,472.392 587.141,472.392 L 246.84,472.392 L 231.84,472.392" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 309 |
<polygon points="28.8,616.032 17.28,620.352 17.28,611.712" style="fill:rgb(0,0,0)"/> |
| 310 |
<path d="M226.08,472.392 L 20.76,472.392 Q 5.76,472.392 5.76,487.392 L 5.76,601.032 Q 5.76,616.032 14.4,616.032 L 23.04,616.032" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 311 |
<polygon points="28.8,510.192 17.28,514.512 17.28,505.872" style="fill:rgb(0,0,0)"/> |
| 312 |
<path d="M5.76,495.072 L 5.76,502.632 Q 5.76,510.192 14.4,510.192 L 23.04,510.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 313 |
<polygon points="226.08,547.992 237.6,543.672 237.6,552.312" style="fill:rgb(0,0,0)"/> |
| 314 |
<path d="M454.003,510.192 L 461.503,510.192 Q 469.003,510.192 469.003,525.192 L 469.003,532.992 Q 469.003,547.992 454.003,547.992 L 246.84,547.992 L 231.84,547.992" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 315 |
<path d="M226.08,547.992 L 20.76,547.992 Q 5.76,547.992 5.76,555.492 L 5.76,562.992" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 316 |
<path d="M240.077,510.192 L 247.577,510.192 Q 255.077,510.192 255.077,525.192 L 255.077,532.992 Q 255.077,547.992 247.577,547.992 L 240.077,547.992" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 317 |
<path d="M312.077,510.192 L 297.077,510.192 Q 282.077,510.192 282.077,495.192 L 282.077,487.392 Q 282.077,472.392 297.077,472.392 L 312.077,472.392" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 318 |
</svg> |
| 319 |
</div><br> |
| 320 |
|
| 321 |
Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> |
| 322 |
References: <a href='./delete-stmt.html'>delete-stmt</a> <a href='./expr.html'>expr</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./update-stmt.html'>update-stmt</a><br></br> |
| 323 |
See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> |
| 324 |
</div> |
| 325 |
|
| 326 |
|
| 327 |
|