Saving Data on Android

todoitemid
.
2. The 
todoname
 column will contain the actual text of the TODO item.
3. The 
todoiscompleted
 column will contain a 
Long
 value that will represent 
whether a TODO item is completed or not.
The database schema
Create_,_Read_,_Update__and_Delete'>Understanding CRUD opera/ons
CRUD
 stands for 
Create
, 
Read
, 
Update
 and 
Delete
. These are the basic operations 
that can be done with a database, to store, maintain and utilize data. Each in turn:
•
Create
: This operation adds a new record to the database. In 
SQL
 or 
Structured 
Query Language
, this is accomplished using an 
Insert into
 statement.
Saving Data on Android
Chapter 3: SQLite Database
raywenderlich.com
50

---

•
Read
: The read operation 
queries
 the database or searches and returns zero to 
many records meeting a specific criteria. In SQL, this is done by using a 
Select 
from
 statement.
•
Update
: The update operation performs a change to an existing record or set of 
records that meet a specific criteria. In SQL, the