MySQL / MariaDB Server Error Codes

Numeric error codes returned by the MySQL and MariaDB server. Clients receive these via the error packet alongside a SQLSTATE value and message string.

82 codes

• 1005 Cannot create table
• 1007 Database already exists
• 1008 Database does not exist
• 1021 Disk full
• 1030 Storage engine error
• 1036 Table is read only
• 1040 Too many connections
• 1044 Access denied for user to database
• 1045 Access denied for user
• 1048 Column cannot be null
• 1049 Unknown database
• 1050 Table already exists
• 1051 Unknown table
• 1052 Ambiguous column
• 1054 Unknown column
• 1060 Duplicate column name
• 1062 Duplicate entry
• 1064 Syntax error
• 1065 Query was empty
• 1066 Not unique table or alias
• 1067 Invalid default value
• 1068 Multiple primary key defined
• 1075 Incorrect auto column definition
• 1091 Column or key does not exist
• 1100 Table locked with read lock
• 1101 BLOB or TEXT cannot have a default value
• 1104 SELECT would examine too many rows
• 1111 Invalid use of group function
• 1113 Table must have at least one column
• 1114 Table is full
• 1129 Host blocked due to many connection errors
• 1130 Host not allowed to connect
• 1136 Column count does not match value count
• 1146 Table doesn't exist
• 1148 Command not allowed
• 1153 Packet bigger than max_allowed_packet
• 1166 Incorrect column name
• 1169 Unique constraint violation on write
• 1171 PRIMARY KEY must be NOT NULL
• 1172 Result contains more than one row
• 1175 Safe update mode
• 1193 Unknown system variable
• 1194 Table is marked as crashed
• 1195 Table repair failed
• 1200 Replica already running
• 1203 Too many user connections
• 1205 Lock wait timeout exceeded
• 1206 Total locks exceeds lock table size
• 1213 Deadlock found
• 1215 Cannot add foreign key constraint
• 1216 Foreign key constraint fails on child insert or update
• 1217 Foreign key constraint fails on parent delete or update
• 1222 UNION columns do not match
• 1223 Conflicting read lock
• 1226 Max queries per hour exceeded
• 1231 Variable cannot be set to NULL
• 1235 Feature not supported in this version
• 1236 Fatal replication error reading binary log
• 1241 Operand must contain one column
• 1242 Subquery returns more than one row
• 1248 Every derived table must have its own alias
• 1251 Client does not support authentication protocol
• 1264 Out of range value for column
• 1267 Illegal mix of collations
• 1286 Unknown storage engine
• 1292 Incorrect value
• 1298 Unknown or incorrect time zone
• 1304 Procedure already exists
• 1305 Procedure does not exist
• 1318 Wrong number of arguments for procedure
• 1320 No RETURN found in function
• 1364 Field has no default value
• 1366 Incorrect integer value
• 1390 Too many placeholders in prepared statement
• 1406 Data too long for column
• 1415 Trigger cannot return result set
• 1418 Function lacks determinism declaration
• 1419 Requires SUPER privilege for binary logging
• 1442 Cannot update table in stored function or trigger
• 1451 Foreign key constraint fails on parent delete
• 1452 Foreign key constraint fails on child insert
• 1461 Too many prepared statements