Changes between Version 49 and Version 50 of Docs/Prog/Manual/ApplicationLibraries/lib825db

Timestamp:

01/20/26 15:04:12 (2 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -140 +140 @@
 }}}
 
-The following example shows creating a table with an integer primary key that auto increments. The keyword is AUTO_INCREMENT in MySQL and AUTOINCREMENT in SQLite. Also note that MySQL will give an error without the AUTO_INCREMENT keyword when INSERT INTO is attempted if "id" is not supplied. SQLite does not require the AUTOINCREMENT keyword for an INTEGER PRIMARY KEY field. SQLite will automatically supply a rowid value for the primary key when INSERT INTO is performed. 
+The following example shows creating a table with an integer primary key that auto increments. The keyword is AUTO_INCREMENT in MySQL and AUTOINCREMENT in SQLite. Also note that MySQL will give an error without the AUTO_INCREMENT keyword when INSERT INTO is attempted if "id" is not supplied. SQLite does not require the AUTOINCREMENT keyword for an INTEGER PRIMARY KEY field. SQLite will automatically supply a rowid value for the primary key when INSERT INTO is performed. However, when AUTOINCREMENT is not used the SQLite may reuse rowid values from deleted rows. (This can be problematic in some cases.)
 {{{#!c++
 string sql;