If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL . will be used as an input for this column, the NULL will be automatically converted into an integer which will one larger than the highest value so far used in that column. If the table is empty, the value 1 will be used.
