SQLITE insert

How do I create an AUTOINCREMENT field? : A column declared INTEGER PRIMARY KEY will autoincrement.

http://www.sqlite.org/faq.html#q1

In SQLite, table rows normally have a 64-bit signed integer ROWID which is unique among all rows in the same table.

If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID.

http://www.sqlite.org/autoinc.html

Inserting, updating, and deleting data in SQLite : http://zetcode.com/db/sqlite/datamanipulation/