Does SQLite have something like insert_id?

Question

I have a c# project that uses sqlite and I wonder if there is something like the mysql_insert_id method as in php ?

Thanks

score 3 · Accepted Answer · edited May 23 '17 at 12:19

3

For SQLite3 SELECT last_insert_rowid() should work, as explained here: how to get last inserted Id of a Sqlite database using Zend_Db

edited May 23 '17 at 12:19

Community

1
1

answered Jun 02 '10 at 10:09

bogdan

671
5
16

score 1 · Answer 2 · answered Jun 02 '10 at 10:08

1

The SQLite base API (in C) has sqlite3_last_insert_rowid which looks ideal for this sort of thing. It's also available at the SQL level via the last_insert_rowid() function. I don't know how this maps to C#, but that should help you when looking.

answered Jun 02 '10 at 10:08

Donal Fellows

133,037
18
149
215

Does SQLite have something like insert_id?

2 Answers2