Method db.delete some rows?

Question

In the table I have 4 fields (note1, note2, note3, Note4). I want to delete all the data in note1 and note2. I have to add arguments to the method db.delete, but I have trouble.

public void delete() {
  SQLiteDatabase db= mHelper.getWritableDatabase();
  db.delete(noteTable.TABLE_NAME, null, null);
}

laalto · Accepted Answer · 2014-04-21 16:58:13Z

1

Delete always deletes entire rows.

To clear values in specific columns, use an update query, for example

ContentValues cv = new ContentValues();
cv.putNull("note1");
cv.putNull("note2");
db.update(noteTable.TABLE_NAME, cv, null, null);

answered Apr 21, 2014 at 16:58

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Method db.delete some rows?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related