How to get _id of last record from sqlite?

Question

I have two table "TABLE_EXAM" and "TABLE_QUESTION". I need to store the question in table with exam id. My question is that how to gel last id of exam table?
Thanks in advance.. Edited Question
Here is my sample code.

public int getLastExamId() { int id2=0; try { SQLiteDatabase db=this.getWritableDatabase(); Cursor cursor=db.rawQuery("SELECT * from SQLITE_SEQUENCE", null); if(cursor.moveToLast()) { id2=cursor.getInt(0); } } catch(Exception e) { e.printStackTrace(); } return id2; }

SELECT MAX(_ID) from TABLE_EXAM.

st0le
– st0le

2012-03-26 13:28:50 +00:00
Commented Mar 26, 2012 at 13:28 — st0le
– st0le, Commented Mar 26, 2012 at 13:28
last record means last inserted record?

ρяσѕρєя K
– ρяσѕρєя K

2012-03-26 13:31:36 +00:00
Commented Mar 26, 2012 at 13:31 — ρяσѕρєя K
– ρяσѕρєя K, Commented Mar 26, 2012 at 13:31
you can store id in public var..

Hasmukh
– Hasmukh

2012-03-26 13:33:04 +00:00
Commented Mar 26, 2012 at 13:33 — Hasmukh
– Hasmukh, Commented Mar 26, 2012 at 13:33
@imrankhan:yes last inserted record....

Sandip Armal Patil
– Sandip Armal Patil

2012-03-26 13:39:33 +00:00
Commented Mar 26, 2012 at 13:39 — Sandip Armal Patil
– Sandip Armal Patil, Commented Mar 26, 2012 at 13:39
you are using AUTOINCREMENT for row id?

ρяσѕρєя K
– ρяσѕρєя K

2012-03-26 13:48:39 +00:00
Commented Mar 26, 2012 at 13:48 — ρяσѕρєя K
– ρяσѕρєя K, Commented Mar 26, 2012 at 13:48

Nixit Patel · Accepted Answer · 2012-04-02 12:34:00Z

4

if you are inserting data using

db.insert(TABEL_NAME, null, values);

then the return value from this function is the id of the row.

answered Apr 2, 2012 at 12:34

Nixit Patel

4,4455 gold badges32 silver badges59 bronze badges

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

2 Comments

vikas Over a year ago

According to developer.android.com/reference/android/database/sqlite/… it seems to be correct, but I think it is returning the number of rows affected by the operation because I am always getting 1 when inserting a new record.

Nixit Patel Over a year ago

actually it works perfect in my case... I have checked this so, many times for conformation... using debugger and logs

Collectives™ on Stack Overflow

How to get _id of last record from sqlite?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related