SQLite usage Record

August 13, 2014 18:20:52

Create a self-increment field in SQLite:

Simple answer: A field declared as an INTEGER PRIMARY KEY is automatically incremented.

Starting with the 2.3.4 version of SQLite, if you declare a field in a table to be an integer PRIMARY KEY, then whenever you insert a null value into that field of the table, the null value is automatically replaced by an integer that is 1 larger than the maximum value of all rows in the field in the table; If the table is empty, it will be replaced with 1.