Deleting Row in SQLite in Android

Question

This might be a dumb question  but I m new to SQLite and I can t seem to figure this out   I have 1 table that has columns KEY ROWID  KEY NAME  KAY LATITUDE  and KEY LONGITUDE   I want the user to be able to select one and delete it  Can anyone give me a direction to start in   My question is in the actual deletion of the row given only its name   Relevant code   public class BeaconDatabase        public static final String KEY ROWID     id       public static final String KEY NAME    beacon name       public static final String KEY LATITUDE    beacon lat       public static final String KEY LONGITUDE    beacon lon        private static final String DATABASE NAME   BeaconDatabase       private static final String DATABASE TABLE   beaconTable       private static final int DATABASE VERSION   1       private DbHelper helper      private final Context context      private SQLiteDatabase db       public BeaconDatabase Context context            this context   context             public BeaconDatabase open             helper   new DbHelper this context           db   helper getWritableDatabase            return this             public void close             helper close               public long createEntry String name  Double lat  Double lon            ContentValues cv   new ContentValues            cv put KEY NAME  name           cv put KEY LATITUDE  lat           cv put KEY LONGITUDE  lon           return db insert DATABASE TABLE  null  cv              public void deleteEntry long row                      Deletes a row given its rowId  but I want to be able to pass                  in the name of the KEY NAME and have it delete that row                  db delete DATABASE TABLE  KEY ROWID         row  null              public String getData             String   columns     KEY ROWID  KEY NAME  KEY LATITUDE  KEY LONGITUDE            Cursor cursor   db query DATABASE TABLE  columns  null  null  null  null  null           String result                int iRow   cursor getColumnIndex KEY ROWID           int iName   cursor getColumnIndex KEY NAME           int iLat   cursor getColumnIndex KEY LATITUDE           int iLon   cursor getColumnIndex KEY LONGITUDE            for  cursor moveToFirst     cursor isAfterLast    cursor moveToNext                  result    cursor getString iRow           cursor getString iName      -     cursor getDouble iLat      latitude     cursor getDouble iLon      longitude n                      return result              private static class DbHelper extends SQLiteOpenHelper            public DbHelper Context context                super context  DATABASE NAME  null  DATABASE VERSION                       Override         public void onCreate SQLiteDatabase db                db execSQL  CREATE TABLE      DATABASE TABLE                               KEY ROWID     INTEGER PRIMARY KEY AUTOINCREMENT                          KEY NAME     TEXT NOT NULL                          KEY LATITUDE     DOUBLE                          KEY LONGITUDE     DOUBLE                                       Override         public void onUpgrade SQLiteDatabase db  int oldVersion  int newVersion                db execSQL  DROP TABLE IF EXISTS     DATABASE TABLE               onCreate db

User · Answer

Try this one   public void deleteEntry long rowId        database delete DATABASE TABLE   KEY ROWID                    rowId  null

User · Answer

To delete rows from a table  you need to provide selection criteria that identify the rows to the delete   method  The mechanism works the same as the selection arguments to the query   method  It divides the selection specification into a selection clause where clause  and selection arguments            SQLiteDatabase db    this getWritableDatabase            Define  where  part of query      String selection   Contract COLUMN COMPANY ID         and                            Contract CLOUMN TYPE                Specify arguments in placeholder order      String   selectionArgs     cid mode           Issue SQL statement      int deletedRows   db delete Contract TABLE NAME                          selection  selectionArgs       return deletedRows    no of rows deleted    The return value for the delete   method indicates the number of rows that were deleted from the database

User · Answer

You can do something like this  sharing my working code snippet  Make sure query is like this     DELETE FROM   tableName WHERE                        KEY  NAME    parameterToMatch    public void removeSingleFeedback InputFeedback itemToDelete                  Open the database             SQLiteDatabase database   this getWritableDatabase                   Execute sql query to remove from database               NOTE  When removing by String in SQL  value must be enclosed with                database execSQL  DELETE FROM     TABLE FEEDBACKS     WHERE                         KEY CUSTMER NAME           itemToDelete getStrCustName                                 AND     KEY DESIGNATION           itemToDelete getStrCustDesignation                                 AND     KEY EMAIL           itemToDelete getStrCustEmail                                 AND     KEY CONTACT NO           itemToDelete getStrCustContactNo                                 AND     KEY MOBILE NO           itemToDelete getStrCustMobile                                 AND     KEY CLUSTER NAME           itemToDelete getStrClusterName                                 AND     KEY PRODUCT NAME           itemToDelete getStrProductName                                 AND     KEY INSTALL VERSION           itemToDelete getStrInstalledVersion                                 AND     KEY REQUIREMENTS           itemToDelete getStrRequirements                                 AND     KEY CHALLENGES           itemToDelete getStrChallenges                                 AND     KEY EXPANSION           itemToDelete getStrFutureExpansion                                 AND     KEY COMMENTS           itemToDelete getStrComments                                       Close the database             database close

User · Answer

Works great   public void deleteNewMelk String melkCode        getWritableDatabase   delete your table  your column        new String   melkCode

User · Answer

public boolean deleteRow long l        String where    ID          l      return db delete TABLE COUNTRY  where  null     0

User · Answer

Try like that may you get your solution  String table    beaconTable   String whereClause     id     String   whereArgs   new String     String valueOf row     db delete table  whereClause  whereArgs

User · Answer

Try this code     private static final String mname     USERNAME    public void deleteContact         db delete TABLE CONTACTS  KEY NAME         mname  null

User · Answer

if you are using SQLiteDatabase   then there is a delete method  Definition of Delete   int delete  String table  String whereClause  String   whereArgs    Example Implementation   Now we can write a method called delete with argument as name  public void delete String value        db delete DATABASE TABLE  KEY NAME         new String   String valueOf value         if you want to delete all records then just pass null to the above method   public void delete         db delete DATABASE TABLE  null  null       Source Of Information

User · Answer

Guys this is a generic method you can use for all your tables  Worked perfectly in my case   public void deleteRowFromTable String tableName  String columnName  String keyValue        String whereClause   columnName             String   whereArgs   new String   String valueOf keyValue        yourDatabase delete tableName  whereClause  whereArgs

User · Answer

This works perfectly   public boolean deleteSingleRow String rowId         return db delete DATABASE TABLE  KEY ROWID         rowId  null   gt  0      You can also refer to this example

User · Answer

Try the below code-  mSQLiteDatabase   getWritableDatabase     To delete   database should be writable  int rowDeleted   mSQLiteDatabase delete TABLE NAME id                              new String    String valueOf id     mSQLiteDatabase close     This is very important once database operation is done  if rowDeleted    0         delete success    else         delete failed

User · Answer

The only way that worked for me was this  fun removeCart mCart  Cart        val db   dbHelper writableDatabase     val deleteLineWithThisValue   mCart f     db delete cons tableNames 3   Cart KEY f      LIKE        deleteLineWithThisValue          null      class Cart       var a  String    null     var b  String    null     var c  String    null     var d  String    null     var e  Int    null     var f  String    null  companion object          Labels Table Columns names     const val rowIdKey     id      const val idKey    id      const val KEY a    a      const val KEY b    b      const val KEY c    c      const val KEY d    d      const val KEY e    e      const val KEY f    f          object cons       val tableNames   arrayOf                0    shoes                 1    hats                 2    shirt                 3    car

User · Answer

Guys if above solutions don t work for you then try this one also because it worked for me   public boolean deleteRow String name         return db delete DATABASE TABLE  KEY NAME          name         null   gt  0

User · Answer

Try this code public void deleteRow String value    SQLiteDatabase db   this getWritableDatabase           db execSQL  quot DELETE FROM  quot    TABLE NAME   quot  WHERE  quot  COlUMN NAME  quot    quot  value  quot   quot    db close

User · Answer

But the Accepted answer Not worked for me  I think String should be In SQL  strings must be quoted  So  in my case this worked for me against the accepted answer    database delete TABLE DAILY NOTES  WORK ENTRY CLUMN NAME    quot    quot    workEntry  quot   quot   null

User · Answer

it s better to use whereargs too   db delete  tablename   id   and name    new String    1   jack       this is like useing this command   delete from tablename where id  1  and name   jack    and using delete function in such way is good because it removes sql injections

User · Answer

You can try like this      ---deletes a particular title--- public boolean deleteTitle String name         return db delete DATABASE TABLE  KEY NAME         name  null   gt  0      or  public boolean deleteTitle String name         return db delete DATABASE TABLE  KEY NAME         new String   name    gt  0

User · Answer

Till i understand your question you want to put two conditions to select a row to be deleted for that you need to do    public void deleteEntry long row String key name           db delete DATABASE TABLE  KEY ROWID         row     and     KEY NAME         key name  null            if you just have key name to select a row you can ignore passing rowid here-row  and use         db delete DATABASE TABLE  KEY NAME         key name  null

[android] Deleting Row in SQLite in Android

Examples related to android

Examples related to sqlite

Examples related to delete-row

Examples related to corresponding-records