How to delete all items from table in SQLite, Android?

Question

CREATE TABLE

private void createSerialDateTable() {
    mDatabase.execSQL(
            "CREATE TABLE IF NOT EXISTS SerialDate (\n" +
                    "    id INTEGER NOT NULL CONSTRAINT SerialDate_pk PRIMARY KEY AUTOINCREMENT,\n" +
                    "    name varchar(200) NOT NULL,\n" +
                    "    joiningdate datetime NOT NULL\n" +
                    ");"
    );
}

INSERT TABLE

 String insertSQL = "INSERT INTO SerialDate \n" +
                "(name, joiningdate)\n" +
                "VALUES \n" +
                "(?, ? );";
        mDatabase.execSQL(insertSQL, new String[]{name, joiningDate});

Delete all items from List I try it But it not working.

clear.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

          //  serialDateList.clear();
            Cursor cursorSerialDate = mDatabase.rawQuery("DELETE  FROM SerialDate", null);
            cursorSerialDate.close();

            adapter.notifyDataSetChanged();
        }
    });

How can I delete all data definitely.
Please. Help me !

Possible duplicate of [How to delete all record from table in sqlite with Android?](https://stackoverflow.com/questions/9599741/how-to-delete-all-record-from-table-in-sqlite-with-android) — , Jul 10 '18 at 16:22
Also another solution but it may be heavier drop the table and recreate another one — Basil Battikhi, Jul 10 '18 at 16:23

score 1 · Accepted Answer · answered Jul 10 '18 at 16:30

1

Try using this code to delete all rows in a table :

database.delete(tablename, null,null);

answered Jul 10 '18 at 16:30

Belbahar Raouf

760
1
4
17

mDatabase.delete(SerialDate, null,null); SerialDate Expression Expected !! what should I do plz !! – Ha Jer Jul 10 '18 at 16:53
Replace SerialDate with "SerialDate" – Belbahar Raouf Jul 11 '18 at 16:32
If this helped you, please mark as answered so other people can find it easily. Thank you. – Belbahar Raouf Jul 12 '18 at 15:48

vinod · Answer 2 · 2018-07-11T08:46:01.163

1

The better way is to create one common method in DataBaseHelper class

public void deleteTableF(String tablename) {

               String selectQuery = "DELETE FROM " + tablename;

               SQLiteDatabase db= this.getWritableDatabase();

               db.execSQL(selectQuery);
            }

And call deleteTableF method where you want to delete a particular table in your code.

SQLiteDatabase db =  = new DataBaseHelper(this); // Dbhelper class object
 db.deleteTableF("table_name");

edited Jul 11 '18 at 08:46

answered Jul 11 '18 at 05:48

vinod

1,126
13
18

SerialDate Expression Expected !! what should I do plz !! [link]( imgur.com/hf3QrUs) – Ha Jer Jul 11 '18 at 16:19
pass your table name in double quotes like mDatabase.delete("SerialDate",null,null) – vinod Jul 12 '18 at 09:34

score 0 · Answer 3 · answered Jul 10 '18 at 16:30

0

rawQuery is used for select statements to fetch rows. Use execSql instead or the delete method

answered Jul 10 '18 at 16:30

score 0 · Answer 4 · answered Jul 11 '18 at 03:08

0

You could try this one

clear.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {

        db.execSQL("DELETE FROM "+ TABLE_NAME);
        db.close();

        // Other codes here
    }
});

answered Jul 11 '18 at 03:08

SerialDate Expression Expected !! what should I do plz !! [link]( https://imgur.com/hf3QrUs) – Ha Jer Jul 11 '18 at 11:17

How to delete all items from table in SQLite, Android?

4 Answers4