Essential SQL and database error codes for PostgreSQL, MySQL, and SQLite.
Akousa23505An INSERT or UPDATE violates a unique constraint or primary key.
23502An INSERT or UPDATE attempted to set a NOT NULL column to NULL.
23503An INSERT or UPDATE violates a foreign key constraint.
23514An INSERT or UPDATE violates a CHECK constraint on the table.
42601The SQL statement contains a syntax error.
42P01The specified table or view does not exist.
42703The specified column does not exist in the table or result set.
08001The client could not establish a connection to the database server.
08003The specified database connection does not exist or has been closed.
08006An established database connection was unexpectedly lost.
40001The transaction was rolled back due to a serialization conflict.
40P01Two or more transactions are waiting for each other's locks, creating a deadlock.
MySQL 1045Authentication failed with the provided credentials.
MySQL 1049The specified database does not exist.
MySQL 1054The specified column does not exist in the table.
MySQL 1062An INSERT or UPDATE would create a duplicate value in a unique index.
MySQL 1146The referenced table does not exist in the database.
SQLITE_BUSY (5)The database file is locked by another connection or process.
SQLITE_LOCKED (6)A table within the database is locked by the same connection.
SQLITE_CONSTRAINT (19)An INSERT, UPDATE, or DELETE violated a constraint.