How to delete all records from table in sqlite with Android

Question

My app has two buttons  the first button is for deleting record on user input and the second button is for deleting all records  But when I want to delete data it shows the message  Your application has been forcefully stopped     Please check my code and give me some suggestion   public void deleteAll           SQLiteDatabase db   this getWritableDatabase          db delete TABLE NAME null null         db execSQL  delete   from   TABLE NAME       db execSQL  TRUNCATE table    TABLE NAME       db close        and  public void delete String id        String   args  id       getWritableDatabase   delete  texts     ID     args       But it shows the following Log cat error     03-07 15 57 07 143  ERROR AndroidRuntime 287   Uncaught handler  thread main exiting due to uncaught exception 03-07 15 57 07 153  ERROR AndroidRuntime 287   java lang NullPointerException 03-07 15 57 07 153  ERROR AndroidRuntime 287       at com example MySQLiteHelper delete MySQLiteHelper java 163  03-07 15 57 07 153  ERROR AndroidRuntime 287       at com example Settings 4 onClick Settings java 94  -07 15 57 07 153  ERROR AndroidRuntime 287       at com android internal app AlertController ButtonHandler handleMessage AlertController java 158  03-07 15 57 07 153  ERROR AndroidRuntime 287       at android os Handler dispatchMessage Handler java 99  03-07 15 57 07 153  ERROR AndroidRuntime 287       at android os Looper loop Looper java 123  03-07 15 57 07 153  ERROR AndroidRuntime 287       at android app ActivityThread main ActivityThread java 4203  03-07 15 57 07 153  ERROR AndroidRuntime 287       at java lang reflect Method invokeNative Native Method  03-07 15 57 07 153  ERROR AndroidRuntime 287       at java lang reflect Method invoke Method java 521  03-07 15 57 07 153  ERROR AndroidRuntime 287       at com android internal os ZygoteInit MethodAndArgsCaller run ZygoteInit java 791  03-07 15 57 07 153  ERROR AndroidRuntime 287       at com android internal os ZygoteInit main ZygoteInit java 549  03-07 15 57 07 153  ERROR AndroidRuntime 287       at dalvik system NativeStart main Native Method

User · Answer

I have a function that works for me in Unity (in conjunction with the database SQLite).

code C#:

public void DeleteAllObj() {
    connectionString = "URI=file:"+Application.dataPath+"/TerrainTools/db/object.sqlite";
    using (IDbConnection dbConnection = new SqliteConnection(connectionString)) {
        dbConnection.Open();
        using(IDbCommand dbCmd =dbConnection.CreateCommand()) {
            dbCmd.CommandText = "DELETE FROM 'ObjectMap'";
            using (IDataReader reader = dbCmd.ExecuteReader()) {
                dbConnection.Close();
                reader.Close();
                return;
            }
        }
    }
}

User · Answer

Using SQLite NET PCL v1 6 292 in VStudio - a lot of the docs and comments out there seem out dated I think    To delete all records   public Task lt int gt  DeleteAllEntry                 return DataBasePath DeleteAllAsync lt tableName gt

User · Answer

db delete TABLE NAME  null  null     or  if you want the function to return the count of deleted rows   db delete TABLE NAME   1   null     From the documentation of SQLiteDatabase delete method      To remove all rows and get a count pass  1  as the whereClause

User · Answer

getContentResolver   delete DB TableName CONTENT URI  null  null

User · Answer

Just Write  SQLiteDatabase db   this getWritableDatabase    db execSQL  delete from   TableName     or   db delete tablename null null

User · Answer

this metod delate all data from database   public void deleteAll         SQLiteDatabase db   this getWritableDatabase        db execSQL  delete from    TABLE NAME       db close

User · Answer

use Sqlit delete function with last two null parameters   db delete TABLE NAME null null

User · Answer

SQLite doesn t support the TRUNCATE command  You should use what you ve tried in the previous line  DELETE FROM  TABLE NAME    P S  You can optimize your program by using the same instance of the database connection for all of your queries to the given database instead of creating a new one for every query

User · Answer

To delete all the rows within the table you can use   db delete TABLE NAME  null  null

User · Answer

you can use two different methods to delete or any query in sqlite android  first method is   public void deleteItem Student item     SQLiteDatabase db   getWritableDatabase     String whereClause    id      String whereArgs      item id toString      db delete  Items   whereClause  whereArgs       second method   public void deleteAll       SQLiteDatabase db   this getWritableDatabase      db execSQL  delete from    TABLE NAME     db close        use any method for your use case

User · Answer

I use this class to handle database I hope it will help some one in future    Happy coding    public class Database    private static class DBHelper extends SQLiteOpenHelper                   Database name             private static final String DB NAME    db name                   Table Names             public static final String TABLE CART    DB CART                     Cart Table Columns             public static final String CART ID PK     id     Primary key      public static final String CART DISH NAME    dish name       public static final String CART DISH ID    menu item id       public static final String CART DISH QTY    dish qty       public static final String CART DISH PRICE    dish price                   String to create reservation tabs table             private final String CREATE TABLE CART    CREATE TABLE IF NOT EXISTS                 TABLE CART                       CART ID PK     INTEGER PRIMARY KEY                  CART DISH NAME     TEXT                   CART DISH ID     TEXT                   CART DISH QTY     TEXT                   CART DISH PRICE     TEXT           public DBHelper Context context            super context  DB NAME  null  2                Override     public void onCreate SQLiteDatabase db            db execSQL CREATE TABLE CART                 Override     public void onUpgrade SQLiteDatabase db  int arg1  int arg2            db execSQL  DROP TABLE IF EXISTS     CREATE TABLE CART           onCreate db                               CART handler                public static class Cart                    Check if Cart is available or not                param context         return             public static boolean isCartAvailable Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase            boolean exists   false           try               String query    SELECT   FROM     DBHelper TABLE CART              Cursor cursor   db rawQuery query  null               exists    cursor getCount    gt  0               cursor close                db close              catch  SQLiteException e                db close                       return exists                         Insert values in cart table                param context         param dishName         param dishPrice         param dishQty         return             public static boolean insertItem Context context  String itemId  String dishName  String dishPrice  String dishQty             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getWritableDatabase            ContentValues values   new ContentValues            values put DBHelper CART DISH ID       itemId           values put DBHelper CART DISH NAME       dishName           values put DBHelper CART DISH PRICE       dishPrice           values put DBHelper CART DISH QTY       dishQty            try               db insert DBHelper TABLE CART  null  values               db close                return true            catch  SQLiteException e                db close                return false                                  Check for specific record by name                param context         param dishName         return             public static boolean isItemAvailable Context context  String dishName             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase            boolean exists   false           String query    SELECT   FROM     DBHelper TABLE CART     WHERE                     DBHelper CART DISH NAME            String valueOf dishName                   try               Cursor cursor   db rawQuery query  null                exists    cursor getCount    gt  0               cursor close               catch  SQLiteException e                 e printStackTrace                db close                        return exists                        Update cart item by item name                param context         param dishName         param dishPrice         param dishQty         return             public static boolean updateItem Context context  String itemId  String dishName  String dishPrice  String dishQty             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getWritableDatabase            ContentValues values   new ContentValues            values put DBHelper CART DISH ID  itemId           values put DBHelper CART DISH NAME  dishName           values put DBHelper CART DISH PRICE  dishPrice           values put DBHelper CART DISH QTY  dishQty            try                String   args   new String   dishName               db update DBHelper TABLE CART  values  DBHelper CART DISH NAME         args                db close                  return true            catch  SQLiteException e                db close                 return false                                  Get cart list                param context         return             public static ArrayList lt CartModel gt  getCartList Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             ArrayList lt CartModel gt  cartList   new ArrayList lt  gt              try               String query    SELECT   FROM     DBHelper TABLE CART                     Cursor cursor   db rawQuery query  null                 for  cursor moveToFirst     cursor isAfterLast    cursor moveToNext                       cartList add new CartModel                          cursor getString cursor getColumnIndex DBHelper CART DISH ID                            cursor getString cursor getColumnIndex DBHelper CART DISH NAME                            cursor getString cursor getColumnIndex DBHelper CART DISH QTY                            Integer parseInt cursor getString cursor getColumnIndex DBHelper CART DISH PRICE                                                   db close               catch  SQLiteException e                db close                      return cartList                       Get total amount of cart items                param context         return             public static String getTotalAmount Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             double totalAmount   0 0           try               String query    SELECT   FROM     DBHelper TABLE CART                     Cursor cursor   db rawQuery query  null                 for  cursor moveToFirst     cursor isAfterLast    cursor moveToNext                       totalAmount   totalAmount   Double parseDouble cursor getString cursor getColumnIndex DBHelper CART DISH PRICE                              Double parseDouble cursor getString cursor getColumnIndex DBHelper CART DISH QTY                                db close                catch  SQLiteException e                db close                        if  totalAmount    0 0              return             else             return      totalAmount                         Get item quantity                param context         param dishName         return             public static String getItemQty Context context  String dishName             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             Cursor cursor   null          String query    SELECT   FROM     DBHelper TABLE CART     WHERE     DBHelper CART DISH NAME            dishName                 String quantity    0            try               cursor   db rawQuery query  null                if  cursor getCount    gt  0                     cursor moveToFirst                    quantity   cursor getString cursor                          getColumnIndex DBHelper CART DISH QTY                     return quantity                            catch  SQLiteException e                e printStackTrace                       return quantity                         Delete cart item by name                param context         param dishName             public static void deleteCartItem Context context  String dishName            DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             try                String   args   new String   dishName               db delete DBHelper TABLE CART  DBHelper CART DISH NAME         args                db close              catch  SQLiteException e                db close                e printStackTrace                          End of cart class         Delete database table        param context     public static void deleteCart Context context        DBHelper dbHelper   new DBHelper context       SQLiteDatabase db   dbHelper getReadableDatabase         try            db execSQL  DELETE FROM     DBHelper TABLE CART          catch  SQLiteException e            e printStackTrace                  Usage      if Database Cart isCartAvailable context            Database deleteCart context

User · Answer

Can be usefull    public boolean deleteAllFood                 SQLiteDatabase db   dbHelper getReadableDatabase                int affectedRows   db delete DBHelper TABLE NAME FOOD  null  null               return affectedRows  gt  0               public class DBProgram       private static DBProgram INSTANCE      private Context context      private DBHelper dbHelper       private DBProgram Context context               burda bu methodu kullanan activity ile eilestiriyoruz         this dbHelper   new DBHelper context              public static synchronized DBProgram getInstance Context context            if  INSTANCE    null                INSTANCE   new DBProgram context                     return INSTANCE                                                                  public boolean updateById ProgramModel program            SQLiteDatabase database   dbHelper getWritableDatabase            ContentValues contentValues   new ContentValues            contentValues put DBHelper COLUM NAME P  program getProgName             contentValues put DBHelper COLUM DAY P  program getDay             contentValues put DBHelper COLUMN WEIGHT P  program getWeight             contentValues put DBHelper COLUMN SET P  program getSet             contentValues put DBHelper COLUMN REPETITION P  program getRepetition             int affectedRows   database update DBHelper TABLE NAME PROGRAM  contentValues   PROG ID P       new String   String valueOf program getId               return affectedRows  gt  0                                                                                                                           TODO     public boolean deleteProgramById int id            SQLiteDatabase database   dbHelper getReadableDatabase            int affectedRows   database delete DBHelper TABLE NAME PROGRAM  DBHelper COLUMN ID P          new String   String valueOf id                return bize etkilenen sira sayisiniini temsil eder         return affectedRows  gt  0                                                                                                                             public boolean deleteProgramByName String progName            SQLiteDatabase database   dbHelper getReadableDatabase            final String whereClause   DBHelper COLUM NAME P                 final String whereArgs      progName           int affectedRows   database delete DBHelper TABLE NAME PROGRAM  whereClause  whereArgs           return affectedRows  gt  0                                                                                                                 get Meal        TODO  WEB Get All  Meals     public List lt ProgramModel gt  getAllProgram String name            List lt ProgramModel gt  foodList   new ArrayList lt  gt             ProgramModel food          SQLiteDatabase database   dbHelper getReadableDatabase            final String kolonlar      DBHelper COLUMN ID P                  DBHelper COLUM NAME P                  DBHelper COLUM DAY P                  DBHelper COLUMN WEIGHT P                  DBHelper COLUMN SET P                  DBHelper COLUMN REPETITION P            final String whereClause   DBHelper COLUM DAY P                 final String whereArgs      name           Cursor cursor   database query DBHelper TABLE NAME PROGRAM  kolonlar  whereClause  whereArgs  null  null  null           while  cursor moveToNext                   food   new ProgramModel                food setId cursor getInt cursor getColumnIndex DBHelper COLUMN ID P                 food setProgName cursor getString cursor getColumnIndex DBHelper COLUM NAME P                 food setDay cursor getString cursor getColumnIndex DBHelper COLUM DAY P                 food setWeight cursor getInt cursor getColumnIndex DBHelper COLUMN WEIGHT P                 food setSet cursor getInt cursor getColumnIndex DBHelper COLUMN SET P                 food setRepetition cursor getInt cursor getColumnIndex DBHelper COLUMN REPETITION P                 foodList add food                     database close            cursor close            return foodList                                                                                                   insert FOOD       TODO LOCAL insert Foods     public boolean insertProgram ProgramModel favorite            boolean result   false          ContentValues contentValues   new ContentValues            contentValues put DBHelper COLUM NAME P  favorite getProgName             contentValues put DBHelper COLUM DAY P  favorite getDay             contentValues put DBHelper COLUMN WEIGHT P  favorite getWeight             contentValues put DBHelper COLUMN SET P  favorite getSet             contentValues put DBHelper COLUMN REPETITION P  favorite getRepetition             SQLiteDatabase database   dbHelper getWritableDatabase            long id   database insert DBHelper TABLE NAME PROGRAM  null  contentValues           if  id    1                result   true                    database close             return result                                                                                                           SQLITE HELPER CLASS                        private class DBHelper extends SQLiteOpenHelper           private final Context context          private static final String DATABASE NAME    PROGRAM INFO           private static final String TABLE NAME PROGRAM    PROGRAM           private static final int DATABASE VERSION   2              FOOD         private static final String COLUMN ID P    PROG ID P           private static final String COLUM NAME P    PROG NAME P           private static final String COLUM DAY P    PROG DAY P           private static final String COLUMN WEIGHT P    PROG WEIGHT P           private static final String COLUMN SET P    PROG SET P           private static final String COLUMN REPETITION P    PROG REPETITION P            private final String CREATE TABLE PROGRAM    CREATE TABLE     TABLE NAME PROGRAM                          COLUMN ID P     INTEGER PRIMARY KEY AUTOINCREMENT                      COLUM NAME P     TEXT                      COLUM DAY P     TEXT                      COLUMN WEIGHT P     INTEGER                      COLUMN SET P     INTEGER                      COLUMN REPETITION P     INTEGER             private static final String DROP TABLE PROGRAM    DROP TABLE IF EXIST     TABLE NAME PROGRAM           public DBHelper Context context                super context  DATABASE NAME  null  DATABASE VERSION               this context   context                      Override         public void onCreate SQLiteDatabase db                db execSQL CREATE TABLE PROGRAM                Util showMessage context   Database Created                        Override         public void onUpgrade SQLiteDatabase db  int oldVersion  int newVersion                db execSQL DROP TABLE PROGRAM               Util showMessage context   Database Upgrated                onCreate db                       Override         public void onDowngrade SQLiteDatabase db  int oldVersion  int newVersion                super onDowngrade db  oldVersion  newVersion

User · Answer

try this code to delete all data from a table    String selectQuery    DELETE FROM table name    Cursor cursor   data1 getReadableDatabase   rawQuery selectQuery  null

User · Answer

Delete all records of table db execSQL  DELETE FROM     TABLE NAME      Reset the auto increment primary key if you needed db execSQL  UPDATE SQLITE SEQUENCE SET SEQ 0 WHERE NAME     TABLE NAME      For go back free space by shrinking sqlite file db execSQL  VACUUM

User · Answer

You missed a space  db execSQL  delete   from     TABLE NAME    Also there is no need to even include    the correct query is   db execSQL  delete from    TABLE NAME

User · Answer

There s no need to use  execute  function The following code worked for me         db delete TABLE NAME null null       db close

User · Answer

SQLiteDatabase db   this getWritableDatabase            db execSQL  DELETE FROM tablename      delete all rows in a table db close      this work for me

User · Answer

Here is simple way to delete   public void deleteItem Item item    SQLiteDatabase db   getWritableDatabase    String whereClause    id     String whereArgs      item id toString     db delete  Items   whereClause  whereArgs       Here whereClause is optional  passing null will delete all rows in table  delete function will return number of affected row if whereClause passed otherwise will return 0      Important Note    If you want to remove all rows and require count of deleted ones also then pass 1 as whereClause

User · Answer

This is working for me  The difference is here with execSQL and rawQuery  The rawQuery use most in searching case and execSQL mostly used in apply operations         truncate the table     ArrayList lt HashMap lt String  String gt  gt  getDatabaseName1 String sr            SQLiteDatabase sqLiteDatabase this getWritableDatabase            sqLiteDatabase execSQL  delete from Hotel            sqLiteDatabase close            return null

[android] How to delete all records from table in sqlite with Android?

Examples related to android

Examples related to sqlite