sqlite db update

Question

Is there an easy way to update a table in sqlite in android? (like a single line in built method) ? I have a table with few columns and primary is one column. I want to search by the primary key and then update a row in the table.

waqaslam · Accepted Answer · 2012-06-11 10:16:34Z

13

To use with predefined update method from android, use it as below:

ContentValues args = new ContentValues();
args.put("col_name", "new value");

db.update("table_name", args, String.format("%s = ?", "primary_column"),
           new String[]{"primary_id"});

Or to run as a single line, go with this (not recommended):

db.execSQL("UPDATE table_name SET col_name='new_value' WHERE
           primary_column='primary_id'");

answered Jun 11, 2012 at 10:16

waqaslam

68.3k17 gold badges172 silver badges180 bronze badges

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

Comments

Moog · Accepted Answer · 2012-06-13 19:18:56Z

6

Read the documentation for SQLiteDatabase.update

You should end up with something like this:

affected = db.update(TABLE_NAME, values, where, whereArgs);

UDPATE

Avoid raw queries using error-prone syntax at all costs. I see a lot of answers here that use a lot of '"' + SOMETHING + "'" ... this is extremely bad practice and you will spend all your time looking for errors on places that are hard to find or simply a complete waste of time.

If you must use raw queries, try forming them with String.format to avoid perilous debug sessions and migraines.

edited Jun 13, 2012 at 19:18

answered Jun 11, 2012 at 10:20

Moog

10.2k2 gold badges42 silver badges68 bronze badges

1 Comment

kouretinho Over a year ago

plus one for the Update. Always prefer the db.update() method instead of the manual raw query. Trying to store a json that contains an apostrophe will convince you too

GAMA · Accepted Answer · 2012-06-11 10:18:16Z

3

You can use rawQuery like this:

cur = mDb.rawQuery("update " + TABLE_NAME
+ " set column1=mango where id='" + _id + "'",null);

where

cur is Cursor object
TABLE_NAME is NAME OF THE TABLE
_id is name of the column (only example)

answered Jun 11, 2012 at 10:18

GAMA

5,99215 gold badges81 silver badges129 bronze badges

2 Comments

harish Over a year ago

Thanks I used this. :) Thanks a lot for the help mate! :)

Moog Over a year ago

Avoid using error-prone syntax by using string.format to build your query i.e String.format("update %s set column1=%s where id='%s'",TABLE_NAME,"mango",_id) @Waqas answer is more correct as it allows for a variable number of fields to be updated without altering the code.

RobGThai · Accepted Answer · 2012-06-11 10:20:02Z

1

Then you should already know what's your primary key.

dbHelper.getWritableDatabase();
ContentValues values = createContentValues(profileVo);
db.update(ProfileVO.TABLE_NAME, values, ProfileVO.COLUMN_ID + "=" + profile.getId(), null)

Here's a good tutorial for you http://www.vogella.com/articles/AndroidSQLite/article.html

answered Jun 11, 2012 at 10:20

RobGThai

5,9798 gold badges44 silver badges61 bronze badges

Comments

pawelzieba · Accepted Answer · 2012-06-11 10:18:01Z

0

The answer is:

http://www.sqlite.org/lang_update.html

and

SQLiteDatabase.rawQuery(...)

answered Jun 11, 2012 at 10:18

pawelzieba

16.1k3 gold badges48 silver badges72 bronze badges

Comments

b.i · Accepted Answer · 2012-06-11 10:20:54Z

0

Try this:

public void updateFunction(int id) {
            String updateStmnt  = "UPDATE  YOUR_TABLE SET YOUR_COLUMN = "
                    + id;
            database.execSQL(updateStmnt);
        }

Hope it will help.

answered Jun 11, 2012 at 10:20

b.i

1,1074 gold badges23 silver badges44 bronze badges

1 Comment

Moog Over a year ago

Consider using string.format instead of + for strings ... it's much more legible and less error-prone

Nadhir Titaouine · Accepted Answer · 2015-06-01 20:27:06Z

0

Using database.update make it simple like this:

ContentValues values = new ContentValues();
    values.put(MySQLiteHelper.COLUMN_NAME, name);
    values.put(MySQLiteHelper.COLUMN_JOB, job);
    values.put(MySQLiteHelper.COLUMN_DATE_START, date_start);
    database.update(MySQLiteHelper.TABLE_EMPLOYEES, values, MySQLiteHelper.COLUMN_ID+"="+id, null);

answered Jun 1, 2015 at 20:27

Nadhir Titaouine

1072 bronze badges

Comments

Mazen Alsenih · Accepted Answer · 2017-06-29 19:06:13Z

0

I know this a bit old, but in case anyone needed another way:

public boolean updateNote(Note note) {
    SQLiteDatabase db = notesDbHelper.getWritableDatabase();

    ContentValues contentValues = new ContentValues();
    contentValues.put(NotesDbContract.NoteEntry._ID, note.getId());
    contentValues.put(NotesDbContract.NoteEntry.COLUMN_NAME_TITLE, note.getTitle());
    contentValues.put(NotesDbContract.NoteEntry.COLUMN_NAME_DSECRIPTION, note.getDescription());

    int result = db.update(NotesDbContract.NoteEntry.TABLE_NAME,
            contentValues,
            NotesDbContract.NoteEntry._ID + "=?", new String[]{String.valueOf(note.getId())}
    );
    db.close();

    return result > 0;
}

answered Jun 29, 2017 at 19:06

Mazen Alsenih

1011 silver badge4 bronze badges

2 Comments

CoolMind Over a year ago

Thanks, but what is another way and why db.close();?

Mazen Alsenih Over a year ago

@CoolMind I recommend using the result to get a return flag about our delete command success, so we can decide how to navigate the code flow based on it, for ex refresh a view to hold the new values.

Collectives™ on Stack Overflow

sqlite db update

8 Answers 8

Comments

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related