AUTOINCREMENT

CREATE TABLE people (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT
);

INSERT INTO people (username) VALUES ('foo');
INSERT INTO people (username) VALUES ('bar');
SELECT * from people;

$ sqlite3 demo.db < autoincrement.sql
1|foo
2|bar

$ rm -f demo.db