Changes between Version 47 and Version 48 of Docs/Prog/Manual/ApplicationLibraries/lib825db
- Timestamp:
- 01/20/26 11:17:56 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Docs/Prog/Manual/ApplicationLibraries/lib825db
v47 v48 140 140 }}} 141 141 142 The following example shows creating a table with PRIMARY KEY AUTO_INCREMENT 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.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. 143 143 {{{#!c++ 144 144 string sql;
![(please configure the [header_logo] section in trac.ini)](/chrome/site/cardinal.gif)