Changes between Version 48 and Version 49 of Docs/Prog/Manual/ApplicationLibraries/lib825db
- Timestamp:
- 01/20/26 11:19:13 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Docs/Prog/Manual/ApplicationLibraries/lib825db
v48 v49 140 140 }}} 141 141 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 valuewhen INSERT INTO is performed.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. SQLite will automatically supply a rowid value for the primary key when INSERT INTO is performed. 143 143 {{{#!c++ 144 144 string sql;
![(please configure the [header_logo] section in trac.ini)](/chrome/site/cardinal.gif)