Good day.
Tell me how in Android SQLite delete all records from the table?
pavlofff
33.7k 5 gold signs 32 silver marks 95 bronze marks
Anatoly Ferisov Anatoly Ferisov
50 10 bronze marks
|
1 answer
You can try this:
db.delete("TABLE_NAME", null, null); be careful with quotes.
Well, or so:
/** * Remove all users and groups from database. */ public void removeAll() { // db.delete(String tableName, String whereClause, String[] whereArgs); // If whereClause is null, it will delete all rows. SQLiteDatabase db = helper.getWritableDatabase(); // helper is object extends SQLiteOpenHelper db.delete(DatabaseHelper.TAB_USERS, null, null); db.delete(DatabaseHelper.TAB_USERS_GROUP, null, null); } pavlofff
33.7k 5 gold signs 32 silver marks 95 bronze marks
elik elik
3,673 2 gold marks 15 silver marks 34 bronze marks
- What is the difference between the first and second options, apart from specifying different table names? - pavlofff
- essentially nothing, the first is the second method is a clear example - elik
|
SQLiteOpenHelperclass has its own methods for inserting, updating, deleting, and selecting from SQLite databases , which are somewhat safer and more concise than raw queries. - pavlofff