

The items from the database are presented to the user per list, each list being displayed on a new fragment, which are displayed on a viewpager. To insert data into a table, you use the INSERT statement. In addition, you can insert a row into a table using data provided by a SELECT statement.


So imagine this is a quick mockup of my database: insert into myTable (col1,col2) select aValue as col1,anotherValue as col2 union select moreValue,evenMoreValue union. SQLite provides various forms of the INSERT statements that allow you to insert a single row, multiple rows, and default values into a table. SQLite creates what youre thinking of as an IDENTITY column using the AUTOINCREMENT keyword.
