How to retrieve the last autoincremented ID from a SQLite table?

by

One other option is to look at the system table sqlite_sequence. Your sqlite database will have that table automatically if you created any table with autoincrement primary key. This table is for sqlite to keep track of the autoincrement field so that it won’t repeat the primary key even after you delete some rows or after some insert failed (read more about this here http://www.sqlite.org/autoinc.html).

So with this table there is the added benefit that you can find out your newly inserted item’s primary key even after you inserted something else (in other tables, of course!). After making sure that your insert is successful (otherwise you will get a false number), you simply need to do:

select seq from sqlite_sequence where name="table_name"

More Related Contents:

  1. Version of SQLite used in Android?
  2. What’s the Hi/Lo algorithm?
  3. Can I have multiple primary keys in a single table?
  4. What are the performance characteristics of sqlite with very large database files? [closed]
  5. Surrogate vs. natural/business keys [closed]
  6. What are the performance improvement of Sequential Guid over standard Guid? [closed]
  7. Copying data from one SQLite database to another
  8. How can I merge many SQLite databases?
  9. What is the difference between an entity relationship model and a relational model?
  10. How to import load a .sql or .csv file into SQLite?
  11. How to recover a corrupt SQLite3 database?
  12. Can we update primary key values of a table?
  13. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  14. Is it fine to have foreign key as primary key?
  15. SQLite UPSERT / UPDATE OR INSERT
  16. How to backup sqlite database?
  17. Deciding between an artificial primary key and a natural key for a Products table
  18. Is there AUTO INCREMENT in SQLite?
  19. GUID vs INT IDENTITY [duplicate]
  20. SQLite insert speed slows as number of records increases due to an index
  21. Convert SQLITE SQL dump file to POSTGRESQL
  22. Limit an sqlite Table’s Maximum Number of Rows
  23. Sqlite in flutter, how database assets work
  24. Android: Where are database files stored?
  25. Can I download an SQLite db on /sdcard and access it from my Android app?
  26. Populate Android Database From CSV file?
  27. Populating Spinner From SQLite Database Android
  28. How to find SQLITE database file version
  29. Maximum number of rows in a sqlite table
  30. Should a database table always have primary keys?

Leave a Comment