Last inserted row with sqlite3 and C

Question

Hi folks,

I wrote a kind of key/value store using sqlite3 and C. my put_pair(key, value) function accepts an empty key as a correct key, and in my INSERT query I use lower(hex(randomblob(16))) to generate a good key for this inserted row.

The problem now is how to retrieve this key and return it by my function?

Answer 1

When the key is not known, try searching by values that match the given condition and return the rows. Or if it is just the most recently inserted row that you are after, look at this page.

Answer 2

You can use sqlite3_last_insert_rowid