Update Column in SQLite

Question

I am learning Android now....I am trying to use SQLite in my application. I am inserting data in table without hassle with below code

public void addQuote(String qu_text, int qu_author, int qu_web_id, String qu_time, int qu_like, int qu_share) {
            open();
            ContentValues v = new ContentValues();
            v.put(QU_TEXT, qu_text);        
            v.put(QU_AUTHOR, qu_author);
            v.put(QU_FAVORITE, "0");        
            v.put(QU_WEB_ID, qu_web_id);
            v.put(QU_TIME, qu_time);
            v.put(QU_LIKE, qu_like);
            v.put(QU_SHARE, qu_share);

            database.insert(TABLE_QUOTES, null, v);

        }

Now I want make another function which can update two column in table called qu_like and qu_share. anyone can please suggest me how can I update only two column instead of full table ?

please clarify: If you are talking about update a column, do you mean specific entries of a row or all rows inside a column? If we are talking about a row, it´s the horizontal line, a column is the vertical line of a table.. — Opiatefuchs, May 22 '17 at 07:20
Syntax for an `execSQL()` instruction: `UPDATE myTable SET Column1 = value1, Column2 = value2 WHERE condition`. Remove the WHERE condition, to update all the rows in your table. And please study some basic SQL. — Phantômaxx, May 22 '17 at 07:23
have you tried something atleast....[Here is similar question](http://stackoverflow.com/questions/9798473/sqlite-in-android-how-to-update-a-specific-row) — ELITE, May 22 '17 at 07:32

Lubomir Babev · Accepted Answer · 2017-05-23T07:48:53.207

0

You can use this method.

public void updateQuote(long qu_id, int qu_like, int qu_share) {
            open();
            ContentValues v = new ContentValues();
            v.put(QU_LIKE, qu_like);
            v.put(QU_SHARE, qu_share);

            database.update(TABLE_QUOTES, v, "qu_id=" + qu_id, null);

        }

edited May 23 '17 at 07:48

answered May 22 '17 at 07:27

Lubomir Babev

1,892
1
12
14

I have primary key for identify called qu_id...Thanks – Priya Patel May 22 '17 at 07:31
If I use above codes....its give me error on "qu_text"=qu_text called variable expected. Thanks – Priya Patel May 22 '17 at 07:38
it should be "qu_id"+"="+ qu_id not "qu_id"=qu_id – Ali Ahsan May 22 '17 at 08:01

Ali Ahsan · Answer 2 · 2017-05-22T08:01:58.823

0

you can try something like that

public void updateRecord(String[] title, long id) {

    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues cv = new ContentValues();

    cv.put(QU_LIKE, title[0]);
    cv.put(QU_LIKE,title[1]);

    db.update(DATABASE_TABLE_NAME, cv, "qu_id" + "=" + id, null);

    db.close();
}

edited May 22 '17 at 08:01

answered May 22 '17 at 07:52

Ali Ahsan

460
3
13

Update Column in SQLite

2 Answers2