summaryrefslogtreecommitdiffstats
path: root/www/autoinc.html
diff options
context:
space:
mode:
Diffstat (limited to 'www/autoinc.html')
-rw-r--r--www/autoinc.html12
1 files changed, 8 insertions, 4 deletions
diff --git a/www/autoinc.html b/www/autoinc.html
index 4923832..a5854bc 100644
--- a/www/autoinc.html
+++ b/www/autoinc.html
@@ -230,9 +230,13 @@ are ignored and can be reused.
<p>
SQLite keeps track of the largest ROWID
using an <a href="fileformat2.html#intschema">internal table</a> named "<a href="fileformat2.html#seqtab">sqlite_sequence</a>".
-The sqlite_sequence table is created
-and initialized automatically whenever a normal table that contains an
-AUTOINCREMENT column is created. The content of the sqlite_sequence table
+The sqlite_sequence table is created automatically, if it does not
+already exist, whenever a normal table that contains an
+AUTOINCREMENT column is created. A row in the sqlite_sequence table
+corresponding to the table with the AUTOINCREMENT column is created the
+first time the AUTOINCREMENT table is written and updated on any
+subsequent writes that increase the maximum rowid.
+The content of the sqlite_sequence table
can be modified using ordinary UPDATE, INSERT, and DELETE statements.
But making modifications to this table will likely perturb the AUTOINCREMENT
key generation algorithm. Make sure you know what you are doing before
@@ -266,5 +270,5 @@ algorithm, AUTOINCREMENT is not allowed on <a href="withoutrowid.html">WITHOUT R
table column other than INTEGER PRIMARY KEY. Any attempt to use
AUTOINCREMENT on a <a href="withoutrowid.html">WITHOUT ROWID</a> table or on a column other than the
INTEGER PRIMARY KEY column results in an error.</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/autoinc.in?m=bd2decf99d">2022-01-08 05:02:57</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/autoinc.in?m=018a064bb6">2024-02-22 16:13:38</a> UTC </small></i></p>