SQL

android studio SQLiteDatabase delete all data in database

db.execSQL("delete from "+ TABLE_NAME);

how to delete data from sql database in android

db.delete("tablename","id=? and name=?",new String[]{"1","jack"});

delete data from database sqlite android

/*Put this in your DAO or in your activity*/

public void delete(int yourvariable){  /*<-----Note: I used Int but you can use what variable you want*/
  db.delete("yourtablename","yourcolumntodothewhere=" + yourvariable ,null);
}