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


Ignore:
Timestamp:
01/20/26 11:19:13 (2 weeks ago)
Author:
Don Wilson
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Docs/Prog/Manual/ApplicationLibraries/lib825db

    v48 v49  
    140140}}}
    141141
    142 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. It will automatically supply a rowid value when INSERT INTO is performed.
     142The 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.
    143143{{{#!c++
    144144string sql;