Debian Codegraph @

www/fullsql.html

raw
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>Full-Featured SQL</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 <div class=fancy>
119 <div class=nosearch>
120 <div class="fancy_title">
121 Full-Featured SQL
122 </div>
123 </div>
124
125
126
127
128
129 <p>
130 Do not be misled by the "Lite" in the name. SQLite has a full-featured
131 SQL implementation, including:
132
133 </p><ul>
134 <li><a href="lang_createtable.html">Tables</a>, <a href="lang_createindex.html">indexes</a>,
135 <a href="lang_createtrigger.html">triggers</a>, and <a href="lang_createview.html">views</a>
136 in unlimited quantity
137 </li><li>Up to 32K columns in a table and unlimited rows
138 </li><li>Multi-column indexes
139 </li><li>Indexes can use <a href="lang_createindex.html#descidx">DESC</a> and <a href="lang_createindex.html#collidx">COLLATE</a>
140 </li><li><a href="partialindex.html">Partial indexes</a>
141 </li><li><a href="expridx.html">Indexes On Expressions</a>
142 </li><li><a href="withoutrowid.html">Clustered indexes</a>
143 </li><li><a href="queryplanner.html#covidx">Covering indexes</a>
144 </li><li><a href="lang_createtable.html#ckconst">CHECK</a>, <a href="lang_createtable.html#uniqueconst">UNIQUE</a>, <a href="lang_createtable.html#notnullconst">NOT NULL</a>, and <a href="foreignkeys.html">FOREIGN KEY constraints</a>.
145 </li><li>ACID transactions using <a href="lang_transaction.html">BEGIN</a>, <a href="lang_transaction.html">COMMIT</a>, and <a href="lang_transaction.html">ROLLBACK</a>
146 </li><li>Nested transactions using <a href="lang_savepoint.html">SAVEPOINT</a>, <a href="lang_savepoint.html">RELEASE</a>, and
147 <a href="lang_transaction.html">ROLLBACK TO</a>
148 </li><li><a href="lang_expr.html#subq">Subqueries</a>, including <a href="lang_expr.html#cosub">correlated subqueries</a>
149 </li><li>Up to 64-way joins
150 </li><li>LEFT, RIGHT, and FULL OUTER JOINs
151 </li><li>DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
152 </li><li>UNION, UNION ALL, INTERSECT, and EXCEPT
153 </li><li>A rich library of <a href="lang_corefunc.html">standard SQL functions</a>
154 </li><li><a href="lang_aggfunc.html">Aggregate functions</a> including DISTINCT aggregates
155 </li><li><a href="windowfunctions.html">Window functions</a>
156 </li><li><a href="lang_update.html">UPDATE</a>, <a href="lang_delete.html">DELETE</a>, and <a href="lang_insert.html">INSERT</a> (of course)
157 </li><li><a href="lang_with.html">Common table expressions</a> including
158 <a href="lang_with.html#recursivecte">recursive common table expressions</a>
159 </li><li><a href="rowvalue.html">Row values</a>
160 </li><li><a href="lang_upsert.html">UPSERT</a>
161 </li><li>An advanced <a href="optoverview.html">query planner</a>
162 </li><li><a href="fts5.html">Full-text search</a>
163 </li><li><a href="rtree.html">R-tree indexes</a>
164 </li><li><a href="json1.html">JSON support</a>
165 </li><li>The <a href="lang_expr.html#isisnot">IS operator</a>
166 </li><li><a href="vtab.html#tabfunc2">Table-valued functions</a>
167 </li><li><a href="lang_replace.html">REPLACE INTO</a>
168 </li><li><a href="lang_vacuum.html">VACUUM</a>
169 </li><li><a href="lang_reindex.html">REINDEX</a>
170 </li><li>The <a href="lang_expr.html#glob">GLOB</a> operator
171 </li><li><a href="lang_expr.html#hexint">Hexadecimal integer literals</a>
172 </li><li>The <a href="lang_conflict.html">ON CONFLICT</a> clause
173 </li><li>The <a href="lang_indexedby.html">INDEXED BY</a> clause
174 </li><li><a href="vtab.html">Virtual tables</a>
175 </li><li>Multiple databases on the same <a href="c3ref/sqlite3.html">database connection</a> using
176 <a href="lang_attach.html">ATTACH DATABASE</a>
177 </li><li>The ability to add <a href="appfunc.html">application-defined SQL functions</a>, including
178 aggregate and table-valued functions.
179 </li><li><a href="c3ref/create_collation.html">Application-defined collating functions</a>
180 </li></ul>
181
182 <p>
183 There are many more features not listed above.
184 SQLite may be small in size and have "Lite" in its name, but it is
185 not lacking in capability.
186 </p><p align="center"><small><i>This page was last updated on 2022-05-10 17:29:14Z </small></i></p>
187