How to get the value of unique primary key id immediately after insertion

Question

I have a sqlite table named as 'TX_TABLE' and the primary key Id name is TX_UID. I insert a row into this table and would like to get the value of this unique id column 'TX_UID". How to get it?

db.insert(VivzHelper.TX_TABLE, null, contentvalues);
String td = new SimpleDateFormat("dd-MM-yyyy").format(new Date());
helper.close();

score 1 · Answer 1 · answered Sep 22 '15 at 08:13

1

Assuming that you are using the Android SQLiteDatabase class, the insert() call returns the row id directly:

public long insert (String table, String nullColumnHack, ContentValues values)

Returns the row ID of the newly inserted row, or -1 if an error occurred

answered Sep 22 '15 at 08:13

Manuel Barbe

2,104
16
21

how to get the value of that row ID? – Rajendran Sep 22 '15 at 08:16
`long rowID = db.insert(...` – Joop Eggen Sep 22 '15 at 08:22
Thanks Joop. It helped me. A simple answer for new entrants. – Rajendran Sep 22 '15 at 09:11

score 0 · Answer 2 · answered Sep 22 '15 at 08:10

You can use the function last_insert_rowid() (click on function name for details) to get the last inserted id.

From documentation:

The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function

It is possible to retrieve it using the following sql command

SELECT last_insert_rowid()

How to get the value of unique primary key id immediately after insertion

2 Answers2