autoincrement
, you have to declare a column of the table to be INTEGER PRIMARY KEY
, then whenever you insert a NULL
into that column of the table, the NULL
is automatically converted into an integer which is one greater than the largest value of that column over all other rows in the table, or 1
if the table is empty.