Predict next auto-inserted row id (SQLite)

by

Try SELECT * FROM SQLITE_SEQUENCE WHERE name="TABLE";. This will contain a field called seq which is the largest number for the selected table. Add 1 to this value to get the next ID.

Also see the SQLite Autoincrement article, which is where the above info came from.

Cheers!

More Related Contents:

  1. Version of SQLite used in Android?
  2. What are the performance characteristics of sqlite with very large database files? [closed]
  3. Copying data from one SQLite database to another
  4. How can I merge many SQLite databases?
  5. How to retrieve the last autoincremented ID from a SQLite table?
  6. How to import load a .sql or .csv file into SQLite?
  7. How to recover a corrupt SQLite3 database?
  8. SQLite UPSERT / UPDATE OR INSERT
  9. How to backup sqlite database?
  10. SQLite insert speed slows as number of records increases due to an index
  11. Convert SQLITE SQL dump file to POSTGRESQL
  12. Limit an sqlite Table’s Maximum Number of Rows
  13. Sqlite in flutter, how database assets work
  14. Android: Where are database files stored?
  15. Can I download an SQLite db on /sdcard and access it from my Android app?
  16. Populate Android Database From CSV file?
  17. Populating Spinner From SQLite Database Android
  18. How to find SQLITE database file version
  19. Maximum number of rows in a sqlite table
  20. What are the performance improvement of Sequential Guid over standard Guid? [closed]
  21. Normalization: What does “repeating groups” mean?
  22. Difference Between Firestore Set with {merge: true} and Update
  23. sqlite select with condition on date
  24. What’s the best way to migrate a Django DB from SQLite to MySQL?
  25. Business Logic: Database or Application Layer
  26. Create SQLite database in android
  27. NULL permitted in Primary Key – why and in which DBMS?
  28. What are the advantages of VistaDB
  29. Personal names in a global application: What to store [closed]
  30. Copy table structure to new table in sqlite3

Leave a Comment