DB
Pro
Product
Pricing
Download
About
Blog
Help
DB Pro Cloud
Learn
/
SQLite
SQLite
Tutorials and error guides with interactive examples.
Quick Reference
SQLite Cheat Sheet
— Complete syntax reference with interactive examples
Guides
The Complete Guide to SQLite JSON Functions
SQLite Full-Text Search: The Hidden Search Engine Inside Your Database
SQLite json_extract: Complete Function Documentation (JSON1)
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
View all errors →
SQLiteSQLite