Last inserted id from SQLite in FireFox add-on

Question

im writing addon for firefox and use SQLite trough XPCOM.

Can anyone explain how to get last inserted id from autoincrement column?

Answer 1

You can use the lastInsertRowId on the connection. However, you should avoid using synchronous statement execution, which means you cannot rely on that property. You'll have to run another SQL query to get that value.

Answer 2

you can use

SELECT last_insert_rowid();