Auto Increment on Composite Primary Key – Sqlite3 + Python

by

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.

More Related Contents:

  1. Importing a CSV file into a sqlite3 database table using Python
  2. Parameter substitution for a SQLite “IN” clause
  3. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  4. List of tables, db schema, dump etc using the Python sqlite3 API
  5. OperationalError: database is locked
  6. Sqlite3, OperationalError: unable to open database file
  7. How to read datetime back from sqlite as a datetime instead of string in Python?
  8. Python CSV to SQLite
  9. Python sqlite3 and concurrency
  10. What if I don’t close the database connection in Python SQLite
  11. Passing a column name in a SELECT statement in Python
  12. Bulk insert huge data into SQLite using Python
  13. How to get a single result from a SQL query in python?
  14. Executing an SQL query over a pandas dataset
  15. “no such table” exception
  16. Is this Python code vulnerable to SQL injection? (SQLite3)
  17. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  18. pysqlite: Placeholder substitution for column or table names?
  19. SQLite not saving data between uses
  20. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  21. Problem with regexp python and sqlite
  22. Python 3 sqlite parameterized SQL-query
  23. Python SQLite3 SQL Injection Vulnerable Code
  24. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  25. How to delete a table in SQLAlchemy?
  26. Python and SQLite: insert into table
  27. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  28. How to check the existence of a row in SQLite with Python?
  29. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment