How to delete the first 10 row from database SQlite in android?

Question

I am building an android application where I am using data helper class to store the data.

Now the problem I am facing is How can I delete top old 10 data from table.

I am using below query but my application crashed.

    public void deleteRec() {
    String ALTER_TBL ="delete from " + TBL_NAME +
            " order by _id LIMIT 3);";
    db.execSQL(ALTER_TBL);
    }

And calling using -

new DatabaseHelper(getApplicationContext()).deleteRec();

Have you tried to take away the last ")" ?

programmer23
– programmer23

2015-02-27 12:46:47 +00:00
Commented Feb 27, 2015 at 12:46 — programmer23
– programmer23, Commented Feb 27, 2015 at 12:46
After remove bracket, change the 3 to 10 ;)

RvdK
– RvdK

2015-02-27 12:49:56 +00:00
Commented Feb 27, 2015 at 12:49 — RvdK
– RvdK, Commented Feb 27, 2015 at 12:49
I updated my answer once check.

Nagaraju V
– Nagaraju V

2015-02-27 13:01:23 +00:00
Commented Feb 27, 2015 at 13:01 — Nagaraju V
– Nagaraju V, Commented Feb 27, 2015 at 13:01

Nagaraju V · Accepted Answer · 2015-02-27 12:58:46Z

2

Once try as follows

String ALTER_TBL ="delete from " + TBL_NAME + " where rowid IN (Select rowid from " + TBL_NAME + " limit 10)";

Hope this will helps you.

edited Feb 27, 2015 at 12:58

answered Feb 27, 2015 at 12:51

Nagaraju V

2,7571 gold badge16 silver badges19 bronze badges

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

Comments

CL. · Accepted Answer · 2015-02-27 13:01:30Z

1

DELETE with LIMIT is not enabled in the SQLite library used in Android.

You have to use a subquery to get the IDs:

String ALTER_TBL = "delete from " + TBL_NAME + " where _id in " +
        "(select _id from " + TBL_NAME + " order by _id limit 10)";

answered Feb 27, 2015 at 13:01

CL.

182k18 gold badges241 silver badges282 bronze badges

1 Comment

ArieKanarie Over a year ago

I guess this is the real reason it didn't work. Beside the ')' that shouldn't be in the query. DELETE with LIMIT has to be enabled with compile options, see: sqlite.org/compile.html#enable_update_delete_limit

Ojonugwa Jude Ochalifu · Accepted Answer · 2015-02-27 12:48:39Z

0

I think your problem is the last parentheses:

enter image description here

answered Feb 27, 2015 at 12:48

Ojonugwa Jude Ochalifu

27.3k26 gold badges125 silver badges136 bronze badges

5 Comments

hitesh matnani Over a year ago

Thanks I too think that this is the problem can you please suggest me better way to do that

Ojonugwa Jude Ochalifu Over a year ago

Remove that and try again.If it gives errors, copy it and add it to your question

hitesh matnani Over a year ago

What I should remove ?

Tommaso Bertoni Over a year ago

you have to remove the bracket

Simas Over a year ago

@hiteshmatnani remove the perenthesis ).

Collectives™ on Stack Overflow

How to delete the first 10 row from database SQlite in android?

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related