Learn
SQLite
Tutorials and error guides with interactive examples.
Quick Reference
Guides
Errors
- SQLITE_CONSTRAINT: UNIQUE constraint failed
- SQLITE_BUSY: database is locked
- no such table: tablename
- NOT NULL constraint failed
- FOREIGN KEY constraint failed
- near "X": syntax error
- attempt to write a readonly database
- database disk image is malformed
- no such column: columnname
- SQLITE_CANTOPEN: unable to open database file
- SQLITE_FULL: database or disk is full
- SQLITE_MISMATCH: datatype mismatch
- column index out of range
- SQLITE_NOTADB: file is not a database
- SQLITE_IOERR: disk I/O error
- SQLITE_SCHEMA: database schema has changed
- SQLITE_TOOBIG: string or BLOB exceeds size limit
- SQLITE_LOCKED: table is locked
- CHECK constraint failed
- ambiguous column name
- table already exists
- index already exists
- too many terms in compound SELECT
- too many columns
- too many SQL variables
- cannot start a transaction within a transaction
- cannot commit/rollback - no transaction is active
- no such function
- misuse of aggregate function
- authorization denied
- SQLITE_INTERRUPT: interrupted
- circular reference in foreign key
- SQLITE_NOMEM: out of memory
- cannot drop table: foreign key constraint
- parser stack overflow
- PRIMARY KEY must be unique
- AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY
- Cannot add a PRIMARY KEY column
- incomplete input
- unrecognized token