SQLite update query Android

Question

The table contains 4 columns : rowID , word , defintition , group_id

I want to change a certain row's word and definition . So here is my code (word is an object where the word , definition , id and the group_id are stored)

   ContentValues values = new ContentValues();

    values.put(KEY_WORD, word.getWord());
    values.put(KEY_DEFINITION, word.getDefinition());
    db.update(TABLE_WORDS, values, KEY_ID, new String [] {String.valueOf(word.getID())});

Can anyone tell me why it only creates a new line instead of changing the row under given ID ?

Digvesh Patel · Accepted Answer · 2014-01-16 13:41:10Z

10

SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(KEY_NAME, contact.getName());
        values.put(KEY_DATE, contact.getDate());

        // updating row
        return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?",
                new String[] { String.valueOf(contact.getID()) });

answered Jan 16, 2014 at 13:41

Digvesh Patel

6,5331 gold badge23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aiyaz Parmar · Accepted Answer · 2015-06-24 08:49:00Z

4

   String id = "1";
   SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COLUMN_NOTIFICATION_STATUS,"canceled");
    db.update(TABLE_NOTIFICATION, values,COLUMN_NOTIFICATION_ID + " = ? ",new String[]{ String.valueOf(id) });

it will work as prepared statement. this piece of code worked in my case .. Thanks

edited Jun 24, 2015 at 8:49

Aiyaz Parmar

5626 silver badges17 bronze badges

answered Mar 7, 2015 at 16:26

Fazal

3,4441 gold badge17 silver badges20 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:09:58Z

1

@Digvesh has the right idea, but because of this limitation, converting an int to a String to use as a selection arg will not work properly. Instead do this:

// assume: SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();
values.put(KEY_WORD, word.getWord());
values.put(KEY_DEFINITION, word.getDefinition());
int rowsUpdated = db.update(TABLE_WORDS, values, KEY_ID + "=" + word.getID(), null);

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Jan 16, 2014 at 16:10

anddev84

1,49313 silver badges32 bronze badges

Comments

Muklas · Accepted Answer · 2017-12-21 12:58:46Z

1

this work for me, while db.rawquery didnot work.

output query

String qu="UPDATE "+ DATABASE_TABLE_DATA + " SET "+isbookmark+" = "+status+" WHERE id = "+uid+";";
db.execSQL(qu);

output query :
UPDATE tabel_data SET `isbookmark` = 1 WHERE id = 2720271;

answered Dec 21, 2017 at 12:58

Muklas

6888 silver badges13 bronze badges

Comments

Ahmad Raza · Accepted Answer · 2014-01-16 13:59:40Z

0

Use LIKE instead of = operator.

SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(KEY_NAME, contact.getName());
        values.put(KEY_DATE, contact.getDate());

        // updating row
        return db.update(TABLE_CONTACTS, values, KEY_ID + " LIKE ?",
                new String[] { String.valueOf(contact.getID()) });

answered Jan 16, 2014 at 13:59

Ahmad Raza

2,8501 gold badge23 silver badges37 bronze badges

Comments

Mukesh Kumar Singh · Accepted Answer · 2014-01-17 06:39:32Z

-2

You can try this using db.rawQuery , i.e.

db.rawQuery("UPDATE "+ TABLE_WORDS + " SET "+ KEY_WORD + " = '"+word.getWord()+"' ,"+KEY_DEFINITION+"= '"+word.getDefinition()+ "' WHERE " + KEY_ID + " = "+word.getID(), null);

Here you don't need to create any ContentValues.

here and here are details

edited Jan 17, 2014 at 6:39

answered Jan 16, 2014 at 14:04

Mukesh Kumar Singh

4,5322 gold badges25 silver badges30 bronze badges

6 Comments

user3199577 Over a year ago

I tried the same query with db.exec (). So what is the difference between those two methods ?

Mukesh Kumar Singh Over a year ago

@user3199577 execSQL(String sql) and execSQL(String sql, Object[] bindArgs) both method do not return any data, but rawQuery(String sql, String[] selectionArgs) returns data into Cursor object

Mukesh Kumar Singh Over a year ago

@user3199577 Let me know if there any problem in above query.

user3199577 Over a year ago

This is the error The method rawQuery(String, String[]) in the type SQLiteDatabase is not applicable for the arguments (String)

anddev84 Over a year ago

I don't see a reason to have to run the raw query and overcomplicate things unnecessarily. update() will work if you know how you're storing data in your DB and you structure your update() query properly. Please see my answer as this should work.

|

Collectives™ on Stack Overflow

SQLite update query Android

6 Answers 6

Comments

Comments

Comments

Comments

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related