How to use the integer datatype autoincrement feature of SQLite3.
How to build sample data.
How to build insert statement
How to query.
introduce the table sqlite_sequence, and show how they work to manage the autoincrementing feature.
How to use DB Browser for SQLite3
How to use the sqlite_sequence table to view the sequence number
software nugget