diff options
Diffstat (limited to 'www/lang_createtable.html')
| -rw-r--r-- | www/lang_createtable.html | 216 |
1 files changed, 108 insertions, 108 deletions
diff --git a/www/lang_createtable.html b/www/lang_createtable.html index 74f1589..e0af7b8 100644 --- a/www/lang_createtable.html +++ b/www/lang_createtable.html @@ -163,8 +163,8 @@ mk.innerHTML = "►"; <h1 id="syntax"><span>1. </span>Syntax</h1> <p><b><a href="syntax/create-table-stmt.html">create-table-stmt:</a></b> -<button id='xcbf666ba' onclick='hideorshow("xcbf666ba","x420b1e16")'>hide</button></p> - <div id='x420b1e16' class='imgcontainer'> +<button id='x84ad63e8' onclick='hideorshow("x84ad63e8","x403f3401")'>hide</button></p> + <div id='x403f3401' class='imgcontainer'> <div style="max-width:718px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 718.33 315.792"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -274,8 +274,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/column-def.html">column-def:</a></b> -<button id='xbb4fe898' onclick='hideorshow("xbb4fe898","x0000a043")'>show</button></p> - <div id='x0000a043' style='display:none;' class='imgcontainer'> +<button id='x9b77352d' onclick='hideorshow("x9b77352d","xf23b4265")'>show</button></p> + <div id='xf23b4265' style='display:none;' class='imgcontainer'> <div style="max-width:614px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 614.333 64.8"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -307,8 +307,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/column-constraint.html">column-constraint:</a></b> -<button id='xe68da4b3' onclick='hideorshow("xe68da4b3","xd27c5702")'>show</button></p> - <div id='xd27c5702' style='display:none;' class='imgcontainer'> +<button id='xbf4852bb' onclick='hideorshow("xbf4852bb","xa4299886")'>show</button></p> + <div id='xa4299886' style='display:none;' class='imgcontainer'> <div style="max-width:844px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 844.306 578.88"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -513,8 +513,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/conflict-clause.html">conflict-clause:</a></b> -<button id='xdfbf5050' onclick='hideorshow("xdfbf5050","x407418c7")'>show</button></p> - <div id='x407418c7' style='display:none;' class='imgcontainer'> +<button id='x96cb5bae' onclick='hideorshow("x96cb5bae","x5aa91fe5")'>show</button></p> + <div id='x5aa91fe5' style='display:none;' class='imgcontainer'> <div style="max-width:451px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 451.517 205.2"> <circle cx="5" cy="6" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,6 20,10 20,2" style="fill:rgb(0,0,0)"/> @@ -571,8 +571,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/expr.html">expr:</a></b> -<button id='x8e975e48' onclick='hideorshow("x8e975e48","x20428343")'>show</button></p> - <div id='x20428343' style='display:none;' class='imgcontainer'> +<button id='xfc548496' onclick='hideorshow("xfc548496","xa40d32bd")'>show</button></p> + <div id='xa40d32bd' style='display:none;' class='imgcontainer'> <div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77"> <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)"/> @@ -1053,8 +1053,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/filter-clause.html">filter-clause:</a></b> -<button id='xb960351e' onclick='hideorshow("xb960351e","x762f8559")'>show</button></p> - <div id='x762f8559' style='display:none;' class='imgcontainer'> +<button id='x13371b04' onclick='hideorshow("x13371b04","x98e2675d")'>show</button></p> + <div id='x98e2675d' style='display:none;' class='imgcontainer'> <div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1084,8 +1084,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/function-arguments.html">function-arguments:</a></b> -<button id='x5dc0c536' onclick='hideorshow("x5dc0c536","x63388e3f")'>show</button></p> - <div id='x63388e3f' style='display:none;' class='imgcontainer'> +<button id='x2fceba9d' onclick='hideorshow("x2fceba9d","xe61bb557")'>show</button></p> + <div id='xe61bb557' style='display:none;' class='imgcontainer'> <div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344"> <circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/> @@ -1147,8 +1147,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='xb9a3679d' onclick='hideorshow("xb9a3679d","xc3a841ed")'>show</button></p> - <div id='xc3a841ed' style='display:none;' class='imgcontainer'> +<button id='xb14cddaa' onclick='hideorshow("xb14cddaa","x2c595708")'>show</button></p> + <div id='x2c595708' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1209,8 +1209,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/over-clause.html">over-clause:</a></b> -<button id='xef9fc78a' onclick='hideorshow("xef9fc78a","x638aaf3d")'>show</button></p> - <div id='x638aaf3d' style='display:none;' class='imgcontainer'> +<button id='x6716c3bd' onclick='hideorshow("x6716c3bd","x6b151803")'>show</button></p> + <div id='x6b151803' style='display:none;' class='imgcontainer'> <div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1301,8 +1301,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='x5701290b' onclick='hideorshow("x5701290b","x8a7e02a3")'>show</button></p> - <div id='x8a7e02a3' style='display:none;' class='imgcontainer'> +<button id='x6a0e783b' onclick='hideorshow("x6a0e783b","x99653543")'>show</button></p> + <div id='x99653543' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -1511,8 +1511,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='xbc518e46' onclick='hideorshow("xbc518e46","x50d35530")'>show</button></p> - <div id='x50d35530' style='display:none;' class='imgcontainer'> +<button id='xdd90de6f' onclick='hideorshow("xdd90de6f","xdf0e8c3a")'>show</button></p> + <div id='xdf0e8c3a' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1573,8 +1573,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/raise-function.html">raise-function:</a></b> -<button id='x9e237ff3' onclick='hideorshow("x9e237ff3","x5cd30db8")'>show</button></p> - <div id='x5cd30db8' style='display:none;' class='imgcontainer'> +<button id='xc5ea6392' onclick='hideorshow("xc5ea6392","xf5ebdca6")'>show</button></p> + <div id='xf5ebdca6' style='display:none;' class='imgcontainer'> <div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1630,8 +1630,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/foreign-key-clause.html">foreign-key-clause:</a></b> -<button id='x210e2e56' onclick='hideorshow("x210e2e56","xc9497f25")'>show</button></p> - <div id='xc9497f25' style='display:none;' class='imgcontainer'> +<button id='x37ac215d' onclick='hideorshow("x37ac215d","x328d817e")'>show</button></p> + <div id='x328d817e' style='display:none;' class='imgcontainer'> <div style="max-width:648px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 648.158 492.48"> <circle cx="5" cy="55" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="45,55 33,59 33,50" style="fill:rgb(0,0,0)"/> @@ -1775,8 +1775,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/literal-value.html">literal-value:</a></b> -<button id='x6780000f' onclick='hideorshow("x6780000f","x79589d80")'>show</button></p> - <div id='x79589d80' style='display:none;' class='imgcontainer'> +<button id='x15e5ac1a' onclick='hideorshow("x15e5ac1a","x49f94d64")'>show</button></p> + <div id='x49f94d64' style='display:none;' class='imgcontainer'> <div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/> @@ -1846,8 +1846,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/signed-number.html">signed-number:</a></b> -<button id='x57a7596c' onclick='hideorshow("x57a7596c","x4c62fc8c")'>show</button></p> - <div id='x4c62fc8c' style='display:none;' class='imgcontainer'> +<button id='x4e0f067d' onclick='hideorshow("x4e0f067d","xd92230f8")'>show</button></p> + <div id='xd92230f8' style='display:none;' class='imgcontainer'> <div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/> @@ -1874,8 +1874,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/type-name.html">type-name:</a></b> -<button id='xc6867d4c' onclick='hideorshow("xc6867d4c","x7519f03c")'>show</button></p> - <div id='x7519f03c' style='display:none;' class='imgcontainer'> +<button id='x27b79522' onclick='hideorshow("x27b79522","xc231b3d7")'>show</button></p> + <div id='xc231b3d7' style='display:none;' class='imgcontainer'> <div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16"> <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)"/> @@ -1929,8 +1929,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/signed-number.html">signed-number:</a></b> -<button id='x5138530d' onclick='hideorshow("x5138530d","x024c317d")'>show</button></p> - <div id='x024c317d' style='display:none;' class='imgcontainer'> +<button id='x0a8f8658' onclick='hideorshow("x0a8f8658","x6fb00734")'>show</button></p> + <div id='x6fb00734' style='display:none;' class='imgcontainer'> <div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/> @@ -1958,8 +1958,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/select-stmt.html">select-stmt:</a></b> -<button id='x3f1902b6' onclick='hideorshow("x3f1902b6","xf87bc594")'>show</button></p> - <div id='xf87bc594' style='display:none;' class='imgcontainer'> +<button id='x80d7b854' onclick='hideorshow("x80d7b854","xc6e5b5de")'>show</button></p> + <div id='xc6e5b5de' style='display:none;' class='imgcontainer'> <div style="max-width:669px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 669.677 1162.3"> <path d="M55,845L667,845L667,99L55,99Z" style="fill:none;stroke-width:3.24;stroke:rgb(211,211,211);" /> <circle cx="6" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> @@ -2237,8 +2237,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/common-table-expression.html">common-table-expression:</a></b> -<button id='x16cf1e35' onclick='hideorshow("x16cf1e35","x124243a8")'>show</button></p> - <div id='x124243a8' style='display:none;' class='imgcontainer'> +<button id='x11d3fa65' onclick='hideorshow("x11d3fa65","xe946ca12")'>show</button></p> + <div id='xe946ca12' style='display:none;' class='imgcontainer'> <div style="max-width:638px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 638.525 167.4"> <circle cx="5" cy="29" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,29 20,33 20,24" style="fill:rgb(0,0,0)"/> @@ -2308,8 +2308,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/compound-operator.html">compound-operator:</a></b> -<button id='xe81acd73' onclick='hideorshow("xe81acd73","x9392760c")'>show</button></p> - <div id='x9392760c' style='display:none;' class='imgcontainer'> +<button id='xa3a95e87' onclick='hideorshow("xa3a95e87","x4ae855ed")'>show</button></p> + <div id='x4ae855ed' style='display:none;' class='imgcontainer'> <div style="max-width:293px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 293.842 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -2350,8 +2350,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/expr.html">expr:</a></b> -<button id='x4d7d83a9' onclick='hideorshow("x4d7d83a9","xe940f54e")'>show</button></p> - <div id='xe940f54e' style='display:none;' class='imgcontainer'> +<button id='xdc5f40dd' onclick='hideorshow("xdc5f40dd","x558f4893")'>show</button></p> + <div id='x558f4893' style='display:none;' class='imgcontainer'> <div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77"> <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)"/> @@ -2832,8 +2832,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/filter-clause.html">filter-clause:</a></b> -<button id='xc1a9d747' onclick='hideorshow("xc1a9d747","xfb84f039")'>show</button></p> - <div id='xfb84f039' style='display:none;' class='imgcontainer'> +<button id='x8099c6d4' onclick='hideorshow("x8099c6d4","x1b6ab860")'>show</button></p> + <div id='x1b6ab860' style='display:none;' class='imgcontainer'> <div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -2863,8 +2863,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/function-arguments.html">function-arguments:</a></b> -<button id='x5dadc732' onclick='hideorshow("x5dadc732","x6cc9b93e")'>show</button></p> - <div id='x6cc9b93e' style='display:none;' class='imgcontainer'> +<button id='xa2183b6d' onclick='hideorshow("xa2183b6d","xe74e1584")'>show</button></p> + <div id='xe74e1584' style='display:none;' class='imgcontainer'> <div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344"> <circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/> @@ -2927,8 +2927,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/literal-value.html">literal-value:</a></b> -<button id='x8c78bcf2' onclick='hideorshow("x8c78bcf2","x3a83543d")'>show</button></p> - <div id='x3a83543d' style='display:none;' class='imgcontainer'> +<button id='xfd379ee5' onclick='hideorshow("xfd379ee5","x31947479")'>show</button></p> + <div id='x31947479' style='display:none;' class='imgcontainer'> <div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/> @@ -2998,8 +2998,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/over-clause.html">over-clause:</a></b> -<button id='x4f3a1b82' onclick='hideorshow("x4f3a1b82","x4f1b25f6")'>show</button></p> - <div id='x4f1b25f6' style='display:none;' class='imgcontainer'> +<button id='xef452b17' onclick='hideorshow("xef452b17","xb37f6983")'>show</button></p> + <div id='xb37f6983' style='display:none;' class='imgcontainer'> <div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -3090,8 +3090,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='x091a770c' onclick='hideorshow("x091a770c","xa0b29580")'>show</button></p> - <div id='xa0b29580' style='display:none;' class='imgcontainer'> +<button id='x6f0f4fc6' onclick='hideorshow("x6f0f4fc6","xae5e122f")'>show</button></p> + <div id='xae5e122f' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -3301,8 +3301,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/raise-function.html">raise-function:</a></b> -<button id='xe41e6c4a' onclick='hideorshow("xe41e6c4a","x9012f6bf")'>show</button></p> - <div id='x9012f6bf' style='display:none;' class='imgcontainer'> +<button id='xf26b9902' onclick='hideorshow("xf26b9902","xd6cc9dfa")'>show</button></p> + <div id='xd6cc9dfa' style='display:none;' class='imgcontainer'> <div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -3357,8 +3357,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/type-name.html">type-name:</a></b> -<button id='x86060bfd' onclick='hideorshow("x86060bfd","x80512457")'>show</button></p> - <div id='x80512457' style='display:none;' class='imgcontainer'> +<button id='x437459f9' onclick='hideorshow("x437459f9","xab54c7de")'>show</button></p> + <div id='xab54c7de' style='display:none;' class='imgcontainer'> <div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16"> <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)"/> @@ -3412,8 +3412,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/signed-number.html">signed-number:</a></b> -<button id='x8f442d75' onclick='hideorshow("x8f442d75","x528c9c16")'>show</button></p> - <div id='x528c9c16' style='display:none;' class='imgcontainer'> +<button id='xf0fc731e' onclick='hideorshow("xf0fc731e","x7b44ee26")'>show</button></p> + <div id='x7b44ee26' style='display:none;' class='imgcontainer'> <div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/> @@ -3441,8 +3441,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/join-clause.html">join-clause:</a></b> -<button id='x09a315fc' onclick='hideorshow("x09a315fc","xe2508c7c")'>show</button></p> - <div id='xe2508c7c' style='display:none;' class='imgcontainer'> +<button id='xdb77d2ec' onclick='hideorshow("xdb77d2ec","xe45c9644")'>show</button></p> + <div id='xe45c9644' style='display:none;' class='imgcontainer'> <div style="max-width:793px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 793.282 84.24"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -3473,8 +3473,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/join-constraint.html">join-constraint:</a></b> -<button id='xef7e6d1a' onclick='hideorshow("xef7e6d1a","xb2dd602e")'>show</button></p> - <div id='xb2dd602e' style='display:none;' class='imgcontainer'> +<button id='xc23016ad' onclick='hideorshow("xc23016ad","xc90253b8")'>show</button></p> + <div id='xc90253b8' style='display:none;' class='imgcontainer'> <div style="max-width:483px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 483.336 126.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,55 39,59 39,50" style="fill:rgb(0,0,0)"/> @@ -3521,8 +3521,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/join-operator.html">join-operator:</a></b> -<button id='xe8d58aba' onclick='hideorshow("xe8d58aba","xecbea229")'>show</button></p> - <div id='xecbea229' style='display:none;' class='imgcontainer'> +<button id='x81b9e9ad' onclick='hideorshow("x81b9e9ad","x2dba1f32")'>show</button></p> + <div id='x2dba1f32' style='display:none;' class='imgcontainer'> <div style="max-width:620px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 620.333 255.312"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,71 39,76 39,67" style="fill:rgb(0,0,0)"/> @@ -3589,8 +3589,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='x7c0e37e3' onclick='hideorshow("x7c0e37e3","xf47be615")'>show</button></p> - <div id='xf47be615' style='display:none;' class='imgcontainer'> +<button id='x64173814' onclick='hideorshow("x64173814","x3ca462f0")'>show</button></p> + <div id='x3ca462f0' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -3650,8 +3650,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/result-column.html">result-column:</a></b> -<button id='x7a43b726' onclick='hideorshow("x7a43b726","xc5e83824")'>show</button></p> - <div id='xc5e83824' style='display:none;' class='imgcontainer'> +<button id='xf46c639c' onclick='hideorshow("xf46c639c","xe80aefbb")'>show</button></p> + <div id='xe80aefbb' style='display:none;' class='imgcontainer'> <div style="max-width:398px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 398.054 163.08"> <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)"/> @@ -3703,8 +3703,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/table-or-subquery.html">table-or-subquery:</a></b> -<button id='xfef8bbbf' onclick='hideorshow("xfef8bbbf","x2be3c08c")'>show</button></p> - <div id='x2be3c08c' style='display:none;' class='imgcontainer'> +<button id='x2195b311' onclick='hideorshow("x2195b311","x196792a4")'>show</button></p> + <div id='x196792a4' style='display:none;' class='imgcontainer'> <div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704"> <circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/> @@ -3848,8 +3848,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/window-defn.html">window-defn:</a></b> -<button id='x8fdd1e91' onclick='hideorshow("x8fdd1e91","xec9d44d1")'>show</button></p> - <div id='xec9d44d1' style='display:none;' class='imgcontainer'> +<button id='x076dffe3' onclick='hideorshow("x076dffe3","xb464c1a3")'>show</button></p> + <div id='xb464c1a3' style='display:none;' class='imgcontainer'> <div style="max-width:479px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 479.765 380.592"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -3929,8 +3929,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='xc293e130' onclick='hideorshow("xc293e130","x7c782c20")'>show</button></p> - <div id='x7c782c20' style='display:none;' class='imgcontainer'> +<button id='xff4e28d5' onclick='hideorshow("xff4e28d5","xdbc1cbfa")'>show</button></p> + <div id='xdbc1cbfa' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -4141,8 +4141,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/table-constraint.html">table-constraint:</a></b> -<button id='xe65e1b29' onclick='hideorshow("xe65e1b29","x71cc4e0d")'>show</button></p> - <div id='x71cc4e0d' style='display:none;' class='imgcontainer'> +<button id='xe9533bcd' onclick='hideorshow("xe9533bcd","x7c6f0198")'>show</button></p> + <div id='x7c6f0198' style='display:none;' class='imgcontainer'> <div style="max-width:751px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 751.325 261.36"> <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)"/> @@ -4249,8 +4249,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/conflict-clause.html">conflict-clause:</a></b> -<button id='xc92a34bf' onclick='hideorshow("xc92a34bf","x0ccd9ab7")'>show</button></p> - <div id='x0ccd9ab7' style='display:none;' class='imgcontainer'> +<button id='x83866d23' onclick='hideorshow("x83866d23","xa5e1382c")'>show</button></p> + <div id='xa5e1382c' style='display:none;' class='imgcontainer'> <div style="max-width:451px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 451.517 205.2"> <circle cx="5" cy="6" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,6 20,10 20,2" style="fill:rgb(0,0,0)"/> @@ -4307,8 +4307,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/expr.html">expr:</a></b> -<button id='x0b931f29' onclick='hideorshow("x0b931f29","xe3c25a2b")'>show</button></p> - <div id='xe3c25a2b' style='display:none;' class='imgcontainer'> +<button id='xd089ea96' onclick='hideorshow("xd089ea96","x678dab74")'>show</button></p> + <div id='x678dab74' style='display:none;' class='imgcontainer'> <div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77"> <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)"/> @@ -4789,8 +4789,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/filter-clause.html">filter-clause:</a></b> -<button id='x12af2551' onclick='hideorshow("x12af2551","xc0fe8fb8")'>show</button></p> - <div id='xc0fe8fb8' style='display:none;' class='imgcontainer'> +<button id='x5bd00ad4' onclick='hideorshow("x5bd00ad4","x686a8c4f")'>show</button></p> + <div id='x686a8c4f' style='display:none;' class='imgcontainer'> <div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -4820,8 +4820,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/function-arguments.html">function-arguments:</a></b> -<button id='xf5f0b1b8' onclick='hideorshow("xf5f0b1b8","x4d172088")'>show</button></p> - <div id='x4d172088' style='display:none;' class='imgcontainer'> +<button id='xcd7c25e7' onclick='hideorshow("xcd7c25e7","xbbc85407")'>show</button></p> + <div id='xbbc85407' style='display:none;' class='imgcontainer'> <div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344"> <circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/> @@ -4883,8 +4883,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='xb6e0b1cb' onclick='hideorshow("xb6e0b1cb","x7e088d4b")'>show</button></p> - <div id='x7e088d4b' style='display:none;' class='imgcontainer'> +<button id='xcfab2326' onclick='hideorshow("xcfab2326","x548d10f0")'>show</button></p> + <div id='x548d10f0' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -4945,8 +4945,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/literal-value.html">literal-value:</a></b> -<button id='xdf755895' onclick='hideorshow("xdf755895","xed2bc12a")'>show</button></p> - <div id='xed2bc12a' style='display:none;' class='imgcontainer'> +<button id='x63e0b147' onclick='hideorshow("x63e0b147","xc0c9f598")'>show</button></p> + <div id='xc0c9f598' style='display:none;' class='imgcontainer'> <div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/> @@ -5016,8 +5016,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/over-clause.html">over-clause:</a></b> -<button id='xed4cb734' onclick='hideorshow("xed4cb734","x36da50a4")'>show</button></p> - <div id='x36da50a4' style='display:none;' class='imgcontainer'> +<button id='x8e43646d' onclick='hideorshow("x8e43646d","x73c1d952")'>show</button></p> + <div id='x73c1d952' style='display:none;' class='imgcontainer'> <div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -5108,8 +5108,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='x0e7210ed' onclick='hideorshow("x0e7210ed","x00a3fe84")'>show</button></p> - <div id='x00a3fe84' style='display:none;' class='imgcontainer'> +<button id='x292d597f' onclick='hideorshow("x292d597f","x6543a272")'>show</button></p> + <div id='x6543a272' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -5318,8 +5318,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='x92f2d92b' onclick='hideorshow("x92f2d92b","x1282b0e9")'>show</button></p> - <div id='x1282b0e9' style='display:none;' class='imgcontainer'> +<button id='x932db091' onclick='hideorshow("x932db091","x54d414bd")'>show</button></p> + <div id='x54d414bd' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -5380,8 +5380,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/raise-function.html">raise-function:</a></b> -<button id='xed8e0ad8' onclick='hideorshow("xed8e0ad8","xb9154ac3")'>show</button></p> - <div id='xb9154ac3' style='display:none;' class='imgcontainer'> +<button id='x52ce1359' onclick='hideorshow("x52ce1359","xea69a5a6")'>show</button></p> + <div id='xea69a5a6' style='display:none;' class='imgcontainer'> <div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -5436,8 +5436,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/type-name.html">type-name:</a></b> -<button id='x540ffe19' onclick='hideorshow("x540ffe19","x0538c621")'>show</button></p> - <div id='x0538c621' style='display:none;' class='imgcontainer'> +<button id='x87b99df1' onclick='hideorshow("x87b99df1","xa4def969")'>show</button></p> + <div id='xa4def969' style='display:none;' class='imgcontainer'> <div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16"> <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)"/> @@ -5491,8 +5491,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/signed-number.html">signed-number:</a></b> -<button id='xf6b2ed8c' onclick='hideorshow("xf6b2ed8c","x6bf5101a")'>show</button></p> - <div id='x6bf5101a' style='display:none;' class='imgcontainer'> +<button id='xe156761e' onclick='hideorshow("xe156761e","xca26ad41")'>show</button></p> + <div id='xca26ad41' style='display:none;' class='imgcontainer'> <div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/> @@ -5520,8 +5520,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/foreign-key-clause.html">foreign-key-clause:</a></b> -<button id='xb53f1579' onclick='hideorshow("xb53f1579","x823fcaf6")'>show</button></p> - <div id='x823fcaf6' style='display:none;' class='imgcontainer'> +<button id='x1587960c' onclick='hideorshow("x1587960c","x300c7cea")'>show</button></p> + <div id='x300c7cea' style='display:none;' class='imgcontainer'> <div style="max-width:648px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 648.158 492.48"> <circle cx="5" cy="55" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="45,55 33,59 33,50" style="fill:rgb(0,0,0)"/> @@ -5665,8 +5665,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/indexed-column.html">indexed-column:</a></b> -<button id='xbe0e5145' onclick='hideorshow("xbe0e5145","x43696a4e")'>show</button></p> - <div id='x43696a4e' style='display:none;' class='imgcontainer'> +<button id='xe9f08736' onclick='hideorshow("xe9f08736","xeb425880")'>show</button></p> + <div id='xeb425880' style='display:none;' class='imgcontainer'> <div style="max-width:696px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 696.36 102.6"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,17 39,21 39,12" style="fill:rgb(0,0,0)"/> @@ -5716,8 +5716,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/table-options.html">table-options:</a></b> -<button id='x8c53d577' onclick='hideorshow("x8c53d577","x9308c71a")'>show</button></p> - <div id='x9308c71a' style='display:none;' class='imgcontainer'> +<button id='x11ecc4e0' onclick='hideorshow("x11ecc4e0","xdbc0b96a")'>show</button></p> + <div id='xdbc0b96a' style='display:none;' class='imgcontainer'> <div style="max-width:324px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 324.036 98.31"> <circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="77,17 66,21 66,12" style="fill:rgb(0,0,0)"/> @@ -5819,7 +5819,7 @@ new table: <p>A "CREATE TABLE ... AS SELECT" statement creates and populates a database table based on the results of a SELECT statement. The table has the same -number of columns as the rows returned by the SELECT statement. The name of +number of columns as the SELECT statement returns. The name of each column is the same as the name of the corresponding column in the result set of the SELECT statement. The declared type of each column is determined by the <a href="datatype3.html#expraff">expression affinity</a> of the corresponding expression in the result set @@ -6134,5 +6134,5 @@ rowid automatically. A detailed description of how this is done is provided <p>The <a href="foreignkeys.html#parentchild">parent key</a> of a <a href="foreignkeys.html">foreign key constraint</a> is not allowed to use the rowid. The parent key must used named columns only.</p> -<p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/lang_createtable.in?m=d5b0680939">2023-02-27 02:07:35</a> UTC </small></i></p> +<p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/lang_createtable.in?m=3a0c300e84">2024-01-31 23:45:50</a> UTC </small></i></p> |