Before we can learn how to use SQLite with Android, we need to first learn the basics of how to use SQLite in general, in a platform neutral context.
Let's look at some example SQL code that could be used on an SQLite database directly, without any Java or Android classes, and then we can more easily understand what our Java code is doing later on.
SQL has keywords, much like Java, that cause things to happen. Here is a flavor of some of the SQL keywords we will soon be using:
INSERT: Allows us to add data to the databaseDELETE: Allows us to remove data from the databaseSELECT: Allows us to read data from the databaseWHERE: Allows us to specify the parts of the database that match a specific criteria we want toINSERT,DELETE,orSELECTfromFROM: Used for specifying a table or column name in a database
Note
There are many more SQLite keywords than this and, for a comprehensive list, take a look at this link: https://sqlite.org/lang_keywords.html.
In addition...