UNIQUE constraint failed

SQLITE_CONSTRAINT_UNIQUE (2067) is returned when an INSERT or UPDATE would create a duplicate value in a column (or combination of columns) declared UNIQUE.

1. 1Inserting a row whose UNIQUE column value already exists in the table.
2. 2Bulk import containing duplicate values in a unique-constrained column.

INSERT or UPDATE violating a UNIQUE constraint.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE users(email TEXT UNIQUE)')
conn.execute("INSERT INTO users VALUES('a@b.com')")
try:
    conn.execute("INSERT INTO users VALUES('a@b.com')")
except sqlite3.IntegrityError as e:
    print(e)  # UNIQUE constraint failed: users.email

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev