Update data in SQLite
"Update data in SQLite" In previous blog we have studied about CREATE,INSERT,SELECT,DELETE operation on SQLite. We missed up about UPDATE operation. Today we are going to learn how to update data in SQLite table. If you understand how to insert data in SQLite, then it is very easy to learn UPDATE. Lets see following code snippet, here i have created two methods one for update mobile number and one for update email. The update() method is used for performing update operation. It contains Table name, content values and where clause. Just copy and paste this method in previous project's SQLiteHelper.java file. //update number public long updateMobileData(String number) { SQLiteDatabase sqLiteDatabase = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL2, number); long result = sqLiteDatabase.update(TableName, contentValues, COL2 + "=?...