Learning Android™ Application Programming: A Hands-On Guide to Building Android Applications

Inserting, Updating, and Deleting Data

You can insert a row of data into a table using the SQL insert statement. The SQL takes this form:

Click here to view code image

insert into <tablename> (<fieldname>, <fieldname> ...)values (<value>, <value> ...);

You can update rows of data in a table using the SQL update statement. To update a single row in a table with a primary key field named _id, the SQL takes this form:

Click here to view code image

update <tablename>set <fieldname> = <value>, <fieldname> = <value> ...where _id= <row_id>;

You can delete a single row of data in a table using the SQL delete statement. To delete a single row in a table with a primary key field named _id, the SQL takes this form:

delete from <tablename>where _id= <row_id>; ...