This book really helped me in best understanding how to use SQLite in Android and contains lots of useful aspects and incredibly informative content that no one knows about SQLite.
You can buy Android SQLite Essentials from the Packt Publishing website: https://www.packtpub.com/application-development/android-sqlite-essentials/book
All SQLite create queries are based on the following syntax diagram:
Here, the keyword create table is used to create a table. This is followed by the table name, the declaration of columns, and their datatype. After preparing our SQL statement, we will execute it using the execSQL() method of the SQLite database.
In case something is wrong with the query statement that we built earlier, we will encounter the exception, android.database.sqlite.SQLiteException. By default, the database is formed in the internal memory space allocated to the application. The folder can be found at
Based on Android SQLite Essentials book: