SQLITE insert

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


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.


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

Blogbook : PHP | Javascript | Laravel | Corcel | CodeIgniter | VueJs | ReactJs | WordPress