SQLite auto-increment non-primary key field

by

You can do select max(id)+1 when you do the insertion.

For example:

INSERT INTO Log (id, rev_no, description)
VALUES ((SELECT MAX(id) + 1 FROM log), 'rev_Id', 'some description')

Note that this will fail on an empty table since there won’t be a record with id is 0 but you can either add a first dummy entry or change the sql statement to this:

INSERT INTO Log (id, rev_no, description)
VALUES ((SELECT IFNULL(MAX(id), 0) + 1 FROM Log), 'rev_Id', 'some description')

More Related Contents:

  1. Is there AUTO INCREMENT in SQLite?
  2. Auto increment table column
  3. SQLite DateTime comparison
  4. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  5. What are valid table names in SQLite?
  6. Reset auto increment counter in postgres
  7. Deleting duplicate rows from sqlite database
  8. What does the SQL Standard say about usage of backtick(`)?
  9. Custom SERIAL / autoincrement per group of values
  10. Delete column from SQLite table
  11. Declare variable in SQLite and use it
  12. sqlite database default time value ‘now’
  13. How do I insert datetime value into a SQLite database?
  14. How to get a list of column names on Sqlite3 database?
  15. How to set auto increment primary key in PostgreSQL?
  16. basic recursive query on sqlite3?
  17. SQLite and custom order by
  18. GROUP_CONCAT in SQLite
  19. Match only entire words with LIKE?
  20. What is causing Foreign Key Mismatch error?
  21. How to split comma-separated values?
  22. sqlite select with condition on date
  23. How to compare sqlite TIMESTAMP values
  24. How do I add a auto_increment primary key in SQL Server database?
  25. SQLite Order By Date1530019888000
  26. SQL – Inserting a row and returning primary key
  27. IF() statement alternative in SQLite
  28. UPSERT *not* INSERT or REPLACE
  29. Drop column from SQLite table
  30. converting int to real in sqlite

Leave a Comment