Auto Increment on Composite Primary Key – Sqlite3 + Python

In sqlite, you only get autoincrement behavior when only one integer column is the primary key. composite keys prevent autoincrement from taking effect.

You can get a similar result by defining id as the only primary key, but then adding an additional unique constraint on id, col3.

If that’s still not quite what you want (say, id’s don’t need to be unique at all), you probably will have to use a trigger to make autoincrement work.

Related Contents:

  1. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  2. Importing a CSV file into a sqlite3 database table using Python
  3. SQLite parameter substitution problem
  4. Variable table name in sqlite
  5. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  6. Force Python to forego native sqlite3 and use the (installed) latest sqlite3 version
  7. Django: Deploying an application on Heroku with sqlite3 as the database
  8. No module named _sqlite3
  9. How do you escape strings for SQLite table/column names in Python?
  10. How to retrieve inserted id after inserting row in SQLite using Python?
  11. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  12. List of tables, db schema, dump etc using the Python sqlite3 API
  13. How to load existing db file to memory in Python sqlite3?
  14. Sqlite insert query not working with python?
  15. OperationalError: database is locked
  16. Python SQLite parameter substitution with wildcards in LIKE
  17. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  18. How can I get dict from sqlite query?
  19. Is there a way to get a list of column names in sqlite?
  20. Sqlite3, OperationalError: unable to open database file
  21. How to get a single result from a SQL query in python?
  22. Using a WHERE ___ IN ___ statement
  23. Parameter substitution for a SQLite “IN” clause
  24. Python insert numpy array into sqlite3 database
  25. How to read datetime back from sqlite as a datetime instead of string in Python?
  26. Python CSV to SQLite
  27. Python sqlite3 and concurrency
  28. Parameter unsupported when inserting int
  29. Python sqlite3 string variable in execute
  30. What if I don’t close the database connection in Python SQLite
  31. Executing an SQL query over a pandas dataset
  32. “no such table” exception
  33. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  34. Is this Python code vulnerable to SQL injection? (SQLite3)
  35. SQLite parameter substitution and quotes
  36. SQLite not saving data between uses
  37. How to create a dynamic filter?
  38. Passing a column name in a SELECT statement in Python
  39. HDF5 – concurrency, compression & I/O performance [closed]
  40. Python SQLite: database is locked
  41. sqlite3.OperationalError: unable to open database file
  42. Bulk insert huge data into SQLite using Python
  43. How can the Euclidean distance be calculated with NumPy?
  44. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  45. Multiple variables in a ‘with’ statement?
  46. How do threads work in Python, and what are common Python-threading specific pitfalls?
  47. test for membership in a 2d numpy array
  48. How to draw a rectangle over a specific region in a matplotlib graph
  49. Adding headers to requests module
  50. Can numpy bincount work with 2D arrays?

Leave a Comment